Example-revoke all on emp from mca12, Database Management System

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







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
Related Questions
What is called query processing? Query processing refers to the range of activities included in extracting data from a database.

The File Based System File based systems are an early attempt to computerise the manual filing system. For example, a manual file can be set up to hold all the correspondence r

Increases efficiency : Data is stored close to most often used site, therefore retrieval would be faster. Also, data that is not required by local applications is not stored, there

Every School has many teachers and many students. Each student is assigned to one school and each teacher works for one school only. Each teacher teaches more than one subject but

These permit the user to unload a database or parts of a database and reload the data on the similar machine, or on another machine in a dissimilar location. This can be useful in

Draw and explain the three level architecture of the database system? A DBMS gives three levels of data is said to follow three-level architecture. The trget of the three-schem

Before we talk about the relational model in more detail, let us first define some very basic terms used in this model. Tuple Every row in a table shows a record and is cal

A file of employee have 10,000 blocks on a cylinder of a disk with characteristics r=8ms and btt=0.6ms I want to know the cost of read inthe file under following conditions for a q

What is magnetic disks?explain it? Magnetic disk provides the bulk of secondary storage of modern computer system. The disk capacity is growing at over 50% per year. But the st

Which component is not included in database environment ? A users component is not included in database environment.