Manage User Roles and Privileges on Autonomous Database
There are several ways to manage user privileges and roles on Autonomous Database. You can use Oracle Database Actions User Management or client-side tools to connect to the database to mange privileges and roles.
Manage Users and User Roles on Autonomous Database - Connecting with Database Actions
You can manage user roles for Autonomous Database users with Oracle Database Actions. The same steps also let you modify account settings for a user.
See The User Management Page for more information on Database Actions User Management.
See Create Users on Autonomous Database - Connecting with Database Actions for information on using Database Actions to create Users.
Manage User Privileges on Autonomous Database - Connecting with a Client Tool
Autonomous Databases come with a predefined database
role named DWROLE
. This role
provides the common privileges for a database
developer or data scientist to perform real-time
analytics. Depending on the usage requirements you
may also need to grant individual privileges to
users.
The privileges in
DWROLE
are the following:
CREATE ANALYTIC VIEW CREATE ATTRIBUTE DIMENSION ALTER SESSION CREATE HIERARCHY CREATE JOB CREATE MATERIALIZED VIEW CREATE MINING MODEL CREATE PROCEDURE CREATE SEQUENCE CREATE SESSION CREATE SYNONYM CREATE TABLE CREATE TRIGGER CREATE TYPE CREATE VIEW READ,WRITE ON directory DATA_PUMP_DIR EXECUTE privilege on the PL/SQL package DBMS_CLOUD EXECUTE privilege on OCI PL/SQL SDK