Create Vector Database Users

You can create a new database user account to provide access to Vector Database using Oracle Database Actions.

To create a vector database user account:

  1. From the Autonomous AI Vector Databases page, click the More actions drop-down list and select Manage Autonomous AI Vector Database Users.
  2. On the Database Actions Database Users page, in the All Users area, click Create User.
  3. Specify the following values on the Create User wizard:

    • User Name: Enter a username for the Autonomous AI Vector Database user.
    • Password: Enter the password for the Autonomous AI Vector Database user.
    • Confirm password: Enter the same password again to confirm the new password.

    The password must meet the strong password complexity criteria based on Oracle Cloud security standards. For more information on the password complexity rules, see About User Passwords on Autonomous Database.

  4. Set a value for the Quota on tablespace DATA for the user. This is a required field.
  5. Select REST, GraphQL, MongoDB API, and Web access to provide access to REST Services, GraphQL and MongoDB APIs, and web access to Database Actions for the new user.
  6. Proceed to the Granted Roles tab, and select the following roles for the vector database user:

    • DB_DEVELOPER_ROLE
    • OML_DEVELOPER

    For each role, select Granted to grant the role, Admin to permit the user to grant the role to other users, or Default to use the default settings for Granted and Admin. A new user is granted CONNECT and RESOURCE roles when Web Access is selected.

  7. Click Create User.

This creates a new database user and grants the required privileges to the vector database user.

You must also enable Resource Principal for the vector user to access Oracle Cloud Infrastructure resources. Run the ENABLE_RESOURCE_PRINCIPAL Procedure as an ADMIN user to grant a user the OCI$RESOURCE_PRINCIPAL privilege in Autonomous AI Database.

See Enable Resource Principal to Access Oracle Cloud Infrastructure Resources for more information.

You can also refer to Create a New Autonomous AI Vector Database User for more information.