Create a New Vector Database User

Complete the following steps to create a new Vector Database user.

1. On the Database Users page within Database Actions, click Create User.
2. Complete the required fields for the new Vector Database user.
   1. Assign the following roles and privileges based on your deployment type:
      • For on-premises deployments:
        • Select Default for the DB_DEVELOPER_ROLE role.
        • The CREATE MINING MODEL privilege must be granted after you create the user.
      • For ADB-S:
        • Select Default for the DB_DEVELOPER_ROLE role.
        • Assign the OML_DEVELOPER role.
        • Assign the OCI$RESOURCE_PRINCIPAL privilege.
   2. Select Enable REST to enable REST for the user.
   3. For ADB-S, select OML to enable Oracle Machine Learning for the user.
   For more information about the required fields, see The Database Users Page.
3. Click Create.
   This creates a new Vector Database user and grants the roles and privileges selected during user creation.
4. For on-premises deployments, grant the CREATE MINING MODEL privilege to the newly created user by executing the following SQL in Database Actions:

   GRANT CREATE MINING MODEL TO <VECTOR_USER>;

5. For ADB-S, enable resource principal for the newly created user by executing the following SQL within Database Actions:

   EXEC DBMS_CLOUD_ADMIN.ENABLE_RESOURCE_PRINCIPAL(username => '<VECTOR_USER>');

   Note:

   Step 4 is necessary for the new user to access the vector database console.

Create a New Vector Database User Using SQL

Complete the following steps to create a new Vector Database user using SQL.

1. In the Database actions dropdown list, select SQL to use a SQL Worksheet.
2. Run the following SQL statements:

   -- Create the user
   create user <VECTOR_USER> identified by "<PASSWORD>";
   
   -- For on-premises deployments, add these roles
   grant db_developer_role to <VECTOR_USER>;
   grant create mining model to <VECTOR_USER>;
   
   –- For ADB-S, add these roles
   grant db_developer_role, oml_developer, oci$resource_principal to <VECTOR_USER>;
   
   -- Enable REST
   exec ords_admin.enable_schema(p_schema => '<VECTOR_USER>');
   
   -- Set Quota
   ALTER USER <VECTOR_USER> QUOTA UNLIMITED ON data;
   
   --For ADB-S: Enable resource principal
   EXEC DBMS_CLOUD_ADMIN.ENABLE_RESOURCE_PRINCIPAL(username => '<VECTOR_USER>');