Managing Users in Autonomous Database

Creating a user

When we provision the autonomous database for the first time, the admin user is already pre-created for you and w provided the password when we created the database.

After that if we want to create additional users as end users to access the database, it is very easy to create the users, this can be done using a regular client utility.

Here DWROLE includes all the necessary privileges for a DW developer/user.

But if we don’t have a client utility to connect to the database it can also be done –

a) Using Database Actions –

We have to go to the OCI console and navigate to  Oracle Database  Autonomous Database  Go inside the ABD created  Database Actions  SQL.

b) Using SQL Developer.

Changing Password of Admin User

If we want to change password for the Database admin user , we can do it using the regular client tool or we can also change it using the OCI console under “More Actions”  Administrator Password