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

Fragmentation, let us consider a table having 2200 records and the fixed si... let us consider a table having 2200 records and the fixed size of the table to be considered as 25.then how many numbers of table is requredto perform horizontal fragmentation

Explain what is rdbms, Explain what is RDBMS ? RDBMS - RDBMS is a datab... Explain what is RDBMS ? RDBMS - RDBMS is a database management system (DBMS) which stores data within the form of relations. Relational databases are powerful since they need f

Define outer union operation of the relational algebra, Define outer union ... Define outer union operation of the relational algebra. Compute the outer union for the relations R and S given below. Outer Join - If there are any values in one tabl

EER models, Ask question #MinimThe Georgia Tech Library (GTL) has approxima... Ask question #MinimThe Georgia Tech Library (GTL) has approximately 16,000 members, 100,000 titles, and 250,000 volumes (an average of 2.5 copies per book). About 10 percent of the

What is outer join, What is Outer join?  They can be employed while we ... What is Outer join?  They can be employed while we want to keep all the tuples in R, or all those in S or all those in both relations in the result of the JOIN in spite of of w

Subclassing, In the ER diagram, one example of subclassing is depicted foll... In the ER diagram, one example of subclassing is depicted following the Services entity. The subclasses Item Based and Time Based are created. The entity Services gains the attribu

In which relational modes cardinality is termed, In which relational modes,... In which relational modes, cardinality is termed? Answer : Cardinality is termed in a number of tuples relational modes.

What is the use of unique function, What is the use of unique function? ... What is the use of unique function? UNIQUE function: If UNIQUE is specified then only unique values are used to computed the mean.

Modular growth, Modular growth: In distributed environments, it is simple t... Modular growth: In distributed environments, it is simple to expand. Latest sites can be added to the network without affecting the operations of other sites, as they are somewhat

What is online transaction processing, What is OLTP (Online Transaction Pro... What is OLTP (Online Transaction Processing)? In OLTP - online transaction processing systems relational database design use the discipline of data modeling and generally follo