Which role is automatically granted to any user created in Autonomous database?

As always, begin by connecting to your server where Oracle is hosted, then connect to Oracle itself as the SYSTEM account.

The SYSTEM account is one of a handful of predefined administrative accounts generated automatically when Oracle is installed. SYSTEM is capable of most administrative tasks, but the task we’re particularly interested in is account management.

Creating a User

Once connected as SYSTEM, simply issue the

GRANT CONNECT TO books_admin;

0 command to generate a new account.

CREATE USER books_admin IDENTIFIED BY MyPassword;

Here we’re simply creating a

GRANT CONNECT TO books_admin;

1 account that is

GRANT CONNECT TO books_admin;

2 or authenticated by the specified

GRANT CONNECT TO books_admin;

3.

The Grant Statement

With our new

GRANT CONNECT TO books_admin;

1 account created, we can now begin adding privileges to the account using the

GRANT CONNECT TO books_admin;

5 statement.

GRANT CONNECT TO books_admin;

5 is a very powerful statement with many possible options, but the core functionality is to manage the privileges of both

GRANT CONNECT TO books_admin;

7 and

GRANT CONNECT TO books_admin;

8 throughout the database.

Providing Roles

Typically, you’ll first want to assign privileges to the user through attaching the account to various roles, starting with the

GRANT CONNECT TO books_admin;

9 role:

GRANT CONNECT TO books_admin;

In some cases to create a more powerful user, you may also consider adding the

GRANT CONNECT, RESOURCE, DBA TO books_admin;

0 role (allowing the user to create named types for custom schemas) or even the

GRANT CONNECT, RESOURCE, DBA TO books_admin;

1 role, which allows the user to not only create custom named types but alter and destroy them as well.

GRANT CONNECT, RESOURCE, DBA TO books_admin;

Assigning Privileges

Next you’ll want to ensure the user has privileges to actually connect to the database and create a session using

GRANT CONNECT, RESOURCE, DBA TO books_admin;

2. We’ll also combine that with all privileges using

GRANT CONNECT, RESOURCE, DBA TO books_admin;

3.

GRANT CREATE SESSION GRANT ANY PRIVILEGE TO books_admin;

We also need to ensure our new user has disk space allocated in the system to actually create or modify tables and data, so we’ll

GRANT CONNECT, RESOURCE, DBA TO books_admin;

4 like so:

GRANT UNLIMITED TABLESPACE TO books_admin;

Table Privileges

While not typically necessary in newer versions of Oracle, some older installations may require that you manually specify the access rights the new user has to a specific schema and database tables.

For example, if we want our

GRANT CONNECT TO books_admin;

1 user to have the ability to perform

GRANT CONNECT, RESOURCE, DBA TO books_admin;

6,

GRANT CONNECT, RESOURCE, DBA TO books_admin;

7,

GRANT CONNECT, RESOURCE, DBA TO books_admin;

8, and

GRANT CONNECT, RESOURCE, DBA TO books_admin;

9 capabilities on the

GRANT CREATE SESSION GRANT ANY PRIVILEGE TO books_admin;

0 table, we might execute the following

GRANT CONNECT TO books_admin;

5 statement:

GRANT
  SELECT,
  INSERT,
  UPDATE,
  DELETE
ON
  schema.books
TO
  books_admin;

This ensures that

GRANT CONNECT TO books_admin;

1 can perform the four basic statements for the

GRANT CREATE SESSION GRANT ANY PRIVILEGE TO books_admin;

0 table that is part of the

GRANT CREATE SESSION GRANT ANY PRIVILEGE TO books_admin;

4 schema.

Which tasks are automatically managed by Oracle autonomous database?

Which two methods can you use to create users and grant roles in autonomous database services choose two?

What are the 3 key capabilities of the autonomous database?

Which task is not automatically performed by the Oracle autonomous database?