Grant Privileges to an Existing Vector Database User
Granting privileges to an existing user involves:
-
Granting user roles
-
Enabling the schema for ORDS
-
Setting a table space quota
-
Enabling resource principal for the user Use the following SQL to prepare the user and enable resource principal:
-- ADD ROLES (safe if already granted)
grant db_developer_role, oml_developer to <VECTOR_USER>;
-- REST ENABLE (safe to re-run)
begin
ords_admin.enable_schema(p_schema => '<VECTOR_USER>');
end;
/
-- QUOTA (overwrites existing quota)
ALTER USER <VECTOR_USER> QUOTA UNLIMITED ON data;
-- OCI$RESOURCE_PRINCIPAL (safe to re-run)
BEGIN
DBMS_CLOUD_ADMIN.ENABLE_RESOURCE_PRINCIPAL(username => '<VECTOR_USER>');
END;
/
See Also: Enable Resource Principal to Access Oracle Cloud Infrastructure Resources