Grant Privileges to an Existing Vector Database User

Granting privileges to an existing user involves:

-- 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