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.
-
Log in to the OCI Console.
-
From the left navigation menu select Oracle AI Database.
-
On the Oracle AI Database page, select Autonomous AI Database.
-
On the Autonomous AI Databases page, select the instance and select View details.
-
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.
-
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>');