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

Sub query in the update command, Sub query in the UPDATE command : Exam... Sub query in the UPDATE command : Example :  //Double  the  commission  for  employees,  who  have  got  at  least  2 increments. UPDATE EMP SET COMM = COMM * 2 WHERE

Define union compatibility, Define union compatibility? Explain why INTERSE... Define union compatibility? Explain why INTERSECTION of two relations cannot be performed if they are not union compatible? Two relations R(A1, A2,-------, An) and S(B1, B2,--

A distributed transaction, A Distributed Transaction Let us demonstrate... A Distributed Transaction Let us demonstrate the concept of a distributed transaction by considering a banking system having of three branches located in 3 different cities. Ev

Data warehouse, XYZ is a large chain of home entertainment rental over 100 ... XYZ is a large chain of home entertainment rental over 100 stores distributed over all states in Australia. XYZ lends entertainment products such as movies, TV shows and games on v

Decomposition, properties of derirable decomposition properties of derirable decomposition

How to rearrange the execution order for efficiency, Rearrange the Executio... Rearrange the Execution Order for Efficiency  Rearranging execution order for efficiency means executing such job that requires less execution time. By rearranging the object

Why dml is used for, Why DML is used for? DML is used to Manipulation and... Why DML is used for? DML is used to Manipulation and processing of database. DML is provided for manipulation & processing of database. (Data stored in the database is processed

Explain function group, What is a function group? A function group is ... What is a function group? A function group is a collection of logically related modules that share global data with every other.  All the modules in the group are contained in

Database recovery and security, Database Recovery And Security Introdu... Database Recovery And Security Introduction In this part we will introduce two main issues relating to database management systems. A computer system suffers from dissi

Index and tree structure, Index And Tree Structure Let us talk about th... Index And Tree Structure Let us talk about the data structure that is used for creating indexes. Can we use Binary Search Tree (BST) as Indexes? Let us initial reconsider