Create a New Autonomous AI Vector Database User Using SQL

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

  1. Log in to the OCI Console.

  2. From the left navigation menu select Oracle AI Database.

  3. On the Oracle AI Database page, select Autonomous AI Database.

  4. On the Autonomous AI Databases page, select the instance and select View details.

  5. On the Autonomous AI Database Details page click the Database actions dropdown list and select SQL to use a SQL Worksheet. See Executing SQL Statements in the Worksheet Editor for more information.

  6. Run the following SQL statements:

    -- USER SQL
    create user <VECTOR_USER> identified by "<PASSWORD>";
    
    -- ADD ROLES
    grant db_developer_role, oml_developer to <VECTOR_USER>;
    
    -- REST ENABLE
    exec ords_admin.enable_schema(p_schema => '<VECTOR_USER>');
    
    -- QUOTA
    ALTER USER <VECTOR_USER> QUOTA UNLIMITED ON data;
    
    -- OCI$RESOURCE_PRINCIPAL
    EXEC DBMS_CLOUD_ADMIN.ENABLE_RESOURCE_PRINCIPAL(username => '<VECTOR_USER>');