7.6.4.1 Grant Privileges for Select AI

To use Select AI, the administrator must grant the EXECUTE privilege on the DBMS_CLOUD_AI package. Learn about additional privileges required for Select AI and its features.

To configure DBMS_CLOUD_AI:

1. Grant the EXECUTE privilege on the DBMS_CLOUD_AI package to the user who wants to use Select AI.

   By default, only the system administrator has EXECUTE privilege. The administrator can grant EXECUTE privilege to other users.

2. Grant EXECUTE privilege on DBMS_CLOUD_PIPELINE to the user who wants to use Select AI with RAG.

   Note:

   If the user already has the DWROLE role, this privilege is included and additional grant is not required.

3. Grant network ACL access to the user who wants to use Select AI and for the AI provider endpoint.

   The system administrator can grant network ACL access. See APPEND_HOST_ACE Procedure for more information.

4. Create a credential to enable access to your AI provider.

   See CREATE_CREDENTIAL Procedure for more information.

5. Grant quotas in tablespace to manage the amount of space in a specific tablespace to the user who wants to use Select AI with RAG.