21.4.2.3 Database Accounts

Database Account Credentials authentication utilizes database schema accounts to authenticate users.

21.4.2.3.1 About Database Account Credentials

Learn about Database Account Credentials.

Database Accounts Credentials authentication requires that a database user (schema) exist in the local database and is unlocked. This authentication method validates end user's credentials against the database accounts repository. Unlike database clients, such as SQL Developer, this authentication method does not establish a new database session for this user. Application code is still executed as the application parsing schema, not as the end user's database schema.

Choose Database Accounts Credentials if having one database account for each named user of your application is feasible and account maintenance using database tools meets your needs (for example, changing end user's password using the ALTER USER statement).

21.4.2.3.2 Setting Up Database Account Credentials

Learn how to set up Database Account Credentials.

To set up Database Account Credentials:

  1. On the Workspace home page, click the App Builder icon.
  2. Select an application.
  3. On the Application home page, click Shared Components.

    The Shared Components page appears.

  4. Under Security, select Authentication Schemes.
  5. On the Authentication Schemes page, click Create.
  6. Select Based on a pre-configured scheme from the gallery and click Next.
  7. Under Name:
    1. Name - Enter the name used to reference the authentication scheme by other application developers.
    2. Scheme Type - Select Database Accounts.
    3. Click Create Authentication Scheme.