Application

Creating and Configuring Database Users

One of a DBA's primary responsibilities is to create and manage database user accounts and to grant or revoke access privileges as needed. Users should be able to access or modify only those parts of the database that they need to perform their jobs.

Use the SQL Command Line in Oracle to perform the following operations:

Note: Save the commands that you use to perform these operations in a Word document.
 
• For the database, create two users, SCOTT and JOY.
• Assign the users privileges to connect to the database.
• Assign SCOTT the privilege to create or modify any table of the database.
• Assign JOY the privilege to create a procedure and execute it.
• Take away the create table privilege from SCOTT and give him the select privilege.

Save a copy of this Application to your portfolio.