Database access for users

By default, users do not have authorization to access the database. However, in some instances, users need access to the database. For example, a user might need database authorization to view tables and columns to create reports.

You can grant a user authorization to read, insert, update, and delete specific objects that define a set of fields and business rules, and that update one or more database tables. Before you can grant database access, you must complete additional steps to grant authorization to database users. To provide a user complete database authorization, use the tools and procedures of your database platform.

Database passwords

The database user ID and password do not have to be the same. However, the database password must meet the requirements of your database platform. For example, if you are using the Oracle database platform, you cannot create a password with certain special characters that Oracle does not support.

You use the Change Password action to change a password for database users. You can set a database user password to match a system password. However, the database user password must support the password requirements. Users cannot change their own database passwords.