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.

Reviews

Write a Review

Basic Computer Science Questions & Answers

  Finding whether two machines are equivalent

Consider the problem of finding whether two of these machines are equivalent. Formulate this problem as the language, and illustrate that it is undecidable.

  Following class definition

Given the following class definition, describe the type of variables used by the arguments and return values of the following member functions (values, pointers, or references):

  Class named commission that includes two numeric variables

Create a class named Commission that includes two numeric variables: a sales figure and a commission rate. Also create two overloaded methods name computeCommission(). The first method takes two numeric arguments representing sales and rate, multi..

  What interface does an application need to use

What interface does an application need to use if it wants to get updates on the current position of the mouse cursor? How does the program get the x,y coordinates of the mouse cursor?

  The current environment

The current environment doesn't have wireless interface, and the management would like to procure a cutting edge wireless technology infrastructure for the organisation.

  What are ids and ips

Write a 2-3 page paper that fully answers the questions.

  Create a console-based application

create a console-based application whose Main() method accepts ten integer values from the user and stores them in an array. Next, create a method that determines and displays the smallest and largest of the ten values

  Develop a technique for machines

For artificial intelligence systems to adapt to new conditions, the 1st task is to construct a technique for machines to resolve problems 'on their own'. To do this, one requires to develop a generic method to resolve generic troubles

  Discuss some options for mobile wireless

Please discuss some options for mobile wireless internet connection, and describe the types of hardware that would be involved in making such a connection

  Advantage to process the data

You can write your program to next the loops in either direction, that is, process row by row or column by column. Explain which way you would choose to process the data. What is the advantage?

  How spki be augmented to support policy

Consider a policy that, for reasons of separation of duties, does not allow an entity to exercise the rights it may grant (delegate) to others. How could SPKI be augmented to support such a policy?

  What were the beliefs of moor and finnis

What were the beliefs of Moor and Finnis. How were they similar and how were they different. Explain if they would apply to users of cyberspace. If they do explain how, if they do not explain how and support your work.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd