Prepare to Use Data Studio

Verify the access and configuration required for Data Studio workflows.

Before You Begin

Ensure that you have the access required for the sign-in method and workflows that you plan to use. The access and configuration depend on the workflow that you want to perform. The capabilities and resources available depend on your assigned roles and permissions.

Note:

Before using database tools, ensure that you have the database user name and password required to connect. For a direct database connection, also ensure that you have the Database Actions URL.

Before using AI-assisted workflows, ensure that the database is AI-ready or can be configured for AI access. If setup is required, check the required Oracle Cloud access in OCI Permissions.

OCI Permissions

OCI Permissions helps you check whether the connected database and your signed-in identity can access the Oracle Cloud Infrastructure resources required for the AI workflows. The results indicate whether additional access is required for the database or for your user account.

Use OCI Permissions when a database status shows Setup needed, or when AI Assistant, AI profiles, or AI-assisted SQL cannot access the required Oracle Cloud services.

Open OCI Permissions

  1. Click the user profile in the header.

  2. Select OCI Permissions. The page displays the following:

    • Database access: Displays the Oracle Cloud resources that the connected database can access. You must be connected to a database to view these details.

    • Your access: Displays the operations that your signed-in identity can perform.

    • Show missing only: This option displays the requirements that are not currently allowed. After the required access is updated, select Refresh to run the check again.

      Note:

      If access is missing, identify whether the requirement is listed under Database access or Your access. Contact your system administrator for further assistance.

Database access

Database access is schema-based. To use database features in Data Studio, connect as a database user whose schema has the access required for the task.

For non-ADMIN users, verify that:

  • The database user exists.

  • The user can connect through Data Studio.

  • Web or REST access is enabled.

  • The user has the database roles required for the Data Studio tools.

The ADMIN user can create users, enable Web and REST access, configure credentials, and grant database roles to other users.

Go to Configure Database Settings to manage users, credentials, AI profiles, and other configuration for the connected database. For more information, see .

For more information, see About Privileges and Roles.

Your access

When you sign in with Oracle Cloud, your signed-in identity must have the required Oracle Cloud Infrastructure Identity and Access Management (IAM) policies for the selected tenancy, region, and compartment.

Required permissions vary by workflow. For example, listing or creating Autonomous Databases, reading Oracle Cloud Infrastructure Object Storage files, using Generative AI, and managing credentials can require different Oracle Cloud permissions.

For more information, see IAM Policies Overview.

Parent topic: Get Started