Configure Database Settings

Configure database users, credentials, AI Profiles, and other settings for the connected database.

Before You Begin

Ensure that:

• You selected or connected to an Autonomous AI Database.

• You are connected as ADMIN or as a database user with the required privileges.

• You have the information required for the credential or AI Profile that you want to create.

• The required OCI Permissions are available when a credential or AI Profile must access Oracle Cloud services.

Access Database Settings

Connect to a database and click the gear icon next to the database name in the header to open Database Settings.

You can then view and configure the following:

• General

  View information about the connected database, such as version, resources, and tags.

• Users

  Create and manage database users. You can also search for users and review their access and REST status.

• SMTP

  Configure email services, such as a local email client on your system.

• Slack

  Configure notification settings when those options are available.

• Credentials

  Create and manage connection information for authentication, services, and integrations.

• AI Profiles

  Create and manage profiles for AI-assisted workflows and configure AI services. While creating an AI Profile, you can select a mode, Essential AI profile, NL2SQL profile, or RAG profile.

For more information, see Data Studio Settings.

Create users, credentials, and AI Profiles as required for the workflows that you want to use. If an AI workflow still shows that setup is required, use OCI Permissions to check the required Oracle Cloud access. See Prepare to Use Data Studio.

Create a Database User

Open the Database Settings page for the connected database and do the following:

1. Go to the Users tab and click Create user.

2. Enter a user name and set the password.

3. Assign a quota for the default tablespace.

   Optionally, you can select whether Password must change or Account locked at the first sign-in.

   Enable for Lakehouse determines whether the user can access external tools and services, such as REST, web access, Data Share, Graph, OML, and Spatial.

4. Under Advanced options, you can grant the required roles to the user.

   You can click Show code to preview the generated SQL.

5. Click Create user to create the database user.

For more information, see The Database Users Page.

Create a Credential

On the Database Settings page, do the following:

1. Go to the Credentials tab and click Create credential.

2. Enter a credential name and, optionally, a description.

3. Select the credential type. You can also use credentials for external providers, such as Azure, AWS, and Google.

4. Enter the required values for the selected credential type.

   Note: The remaining fields depend on the credential type you select. Most credential types require a user name and password. For an OCI Signing Keys credential, the required values include the User OCID, Tenancy OCID, Fingerprint, and Private key.

   You can select the option Use as default credential, if required.

5. Click Create credential.

For more information, see Create Credentials.

Create an AI Profile

On the Database Settings page, do the following:

1. Go to the AI Profiles tab.

2. Click Create AI profile and select a mode:

   • Essential AI profile: to create a basic AI Profile with limited features.

   • NL2SQL profile: to use object lists of table metadata for generating queries.

   • RAG profile: to use Vector Index and Embedding Model for semantic search over unstructured data.

   Specify the mandatory Service settings for the AI Profile.

3. Enter a Profile name and select the AI provider, Credential, OCI region, and AI model.

4. Under Advanced settings, you can review or change additional options, such as settings for cloud services and Generative AI Services that the AI Profile can use.

5. Click Create AI profile.

For more information, see Create an AI Profile.