Step 3 - Create a Resource by a User

Log in as user2, create a database, and have exclusive access to the database. First, log in as user2 with the temporary password created by odaadmin.

Oracle Database Appliance BUI login

A new password for user2 is required.  You can use a password similar to WELcome12##, or create your own.

Oracle Database Appliance BUI login

Log in as user2 with the new password.

System Information

Click on the Database tab.  There are no database available to user2.  Click Create Database.

Databases page

Create a new database, user2db1.

Create Database

Click Create and verify that the database is created.

Databases Information

Log in as user1 to verify that user1 does not have access to user2db1.

Oracle Database Appliance BUI login

You can verify that user1 only has access to db5.

Databases Information

Log in as odaadmin to review resources and user access.

Oracle Database Appliance BUI login

When logged in as the odaadmin user, you can view all the databases.

Databases Information

Click on the Multi-User Access tab, then click on the Resources tab on the left.  Use the Advanced Search feature and search for ODA_DB, You can see the Primary Owner of the database and Shared Access users for the databases.  The user1 has access to db5, and user2 has access to user2db1.

Databases Information

This concludes Lab 5.