Example:  //REVOKE ALL ON EMP FROM MCA12;

                             (All permissions will be cancelled)

You can also cancel only some of the permissions.

Drop: A user-id can be deleted by using drop command.

 

Example:

 DROP USER MCA12;

 

Posted Date: 3/11/2013 1:17:31 AM | Location : United States

Ask an Expert

Related Discussions:- Example-revoke all on emp from mca12, Assignment Help, Ask Question on Example-revoke all on emp from mca12, Get Answer, Expert's Help, Example-revoke all on emp from mca12 Discussions

Write discussion on Example-revoke all on emp from mca12
Your posts are moderated

Write your message here..

Related Questions

Although how will the system recover, Although how will the system recover ... Although how will the system recover The selection of REDO or UNDO for a transaction for the recovery is completed on the basis of the state of the transactions. This state is

ER diagram, #question. acompani datdbase needs to store information about e... #question. acompani datdbase needs to store information about employees (identified by a social security number,with salary and phone as attributes) and departments (identified by

Complete replication-data replication, Complete replication: It implies ma... Complete replication: It implies maintaining of a whole copy of the database at every site. Thus, the reliability & availability and performance for query response are maximized.

Define the basic operations of the relational algebra, Define the basic ope... Define the basic operations of the relational algebra?     Ans: Basic operators of relational algebra are: 1. Union (∪) - Selects tuples which are in either P or Q or in bot

Graphical user interface tools, These are interactive interfaces, graphical... These are interactive interfaces, graphical that hide the difficulty of the DBMS and query language behind an intuitive, simple to understand, and convenient interface. This permit

Primary key, explaination explaination

E-R MODEL, WHAT IS MEANT BY E-R MODEL WHAT IS MEANT BY E-R MODEL

What is average response time, What is average response time? The avera... What is average response time? The average response time is that the average time for a transaction to be done after it has been submitted.

Relational algebra, Consider the relation schemas as follows. works (per... Consider the relation schemas as follows. works (person name, company name, salary); lives (person name, street, city); located in(company name, city); managers (person name

Create a customer database and apply queries, For the question given below,... For the question given below, you are required to submit design and implementation documentation as described over the page. Design, implement (in Java), test and document a set of