Use the sql command line in oracle to perform

Assignment Help Basic Computer Science

Reference no: EM13215184

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.

Reference no: EM13215184

Questions Cloud

Show on the console the sum of all non-inherited data member : show on the console the sum of all non-inherited data members of every instance in the program by Display() function.

Prepare all entries required to properly record the sale : On April 1, 2014, West Company purchased $476,000 of 5.25% bonds for $494,790 plus accrued interest as an available-for-sale security. Interest is paid on July 1 and January 1 and the bonds mature on July 1, 2019.

What are the main disadvantages of hypermedia : What are the main disadvantages of hypermedia when compared with conventional media such as books and videos?

How could the company have reduced the costs : In a recent year, an oil refinery in Texas City, Texas, on the Houston Ship Channel exploded. The explosion killed 14 people and sent a plume of smoke hundreds of feet into the air. The blast started as a fire in the section of the plant that incr..

Use the sql command line in oracle to perform : 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 jo..

Why wouldnt tax researcher just consult internal revenue : The Internal Revenue Code is the most authoritative source of income tax law. In trying to resolve an income tax question, however, a tax researcher also consults administrative rulings (Income Tax Regulations, Revenue Rulings, etc.) and court dec..

Identify tactical : Conduct research to find examples of the differences between I.T. security controls and countermeasure gap analysis, and identify tactical, strategic, risk mitigation, threats, and vulnerability dimensions and gaps associated with compliance recom..

How offset potential negative implications of the adoption : Develop a virtualization adoption plan applicable to the scenario by doing the following.

Compute gibsons investment in miller companys balance : On July 1, 2011, Gibson Company acquired 75,000 of the outstanding shares of Miller Company for $12 per share. This acquisition gave Gibson a 35 percent ownership of Miller and allowed Gibson to significantly influence the investee's decisions.

User Account

All Pages