Set Up Spatial Studio Users and Privileges

Learn about creating and assigning privileges for Spatial Studio users.

Perform the following steps to set up a Spatial Studio user with the correct set of roles and privileges using Oracle Database Actions:

1. Sign in to Oracle Cloud and navigate to your Oracle Autonomous AI Database instance.
2. Access Database Actions from the Oracle Cloud Infrastructure Console as an ADMIN user.
   See Access Database Actions as ADMIN for more information.
3. Click Database Users in the Launchpad page under the Administration group.
4. Click Create User on the Database Users page, in the All Users area.
   The Create User slider opens and displays the Users tab by default.
5. Enter User Name and Password, then re-enter the password to confirm.
6. Select a quota from the Quota on tablespace DATA drop-down.
7. Click the Granted Roles tab and grant the required Spatial Studio role to the database user.
   Search for the required role that you wish to grant. Supported Spatial Studio roles are: SPATIAL_ADMIN, SPATIAL_AUTHOR, and SPATIAL_CONSUMER.

   See About Spatial Studio User Roles for more information on the different roles supported in Spatial Studio.

   Note that if the database user is not assigned any Spatial Studio user role, then the user is considered a read-only (SPATIAL_CONSUMER) user and can perform only limited actions in Spatial Studio. See Read-Only User: SPATIAL_CONSUMER for more information.

8. Click Create User to set up the new user in the database.
9. Navigate to the SQL page in Database Actions.
   See The SQL Page for more information.
10. Grant the appropriate privileges based on the Spatial Studio role assigned to the database user in step 7.
    • SPATIAL_ADMIN or SPATIAL_AUTHOR

      GRANT CREATE SESSION, CREATE TABLE, CREATE VIEW, CREATE SEQUENCE, CREATE PROCEDURE, CREATE TYPE, CREATE SYNONYM, CREATE TRIGGER TO <db_user>;

    • SPATIAL_CONSUMER

      GRANT CREATE SESSION, CREATE TABLE, CREATE VIEW TO <db_user>;

11. Grant the database user connect to Spatial Studio through a proxy user as shown.

    ALTER USER <db_user> GRANT CONNECT THROUGH "SPATIAL$PROXY_USER";

    The database user is set with all the required privileges and can now log into Spatial Studio.