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
Differentiate between logical database design and physical database design. Show how this separation leads to data independence? Basis Logical Databas

Define about the Stored Procedure - It's a set of T-SQL statements combined together to perform a single task formed by combining numerous small tasks. - When you essentiall

What do you mean through integrity constraints? Integrity Constraints -An integrity constraint is a condition specified on a database schema and restricts the data in which

After the completion of the logical model the physical model is to be made. The oracle 10 G will be used as a database server and all the tables with their column are created and i

Performance of Various Concurrency Control Mechanisms

QUESTION (a)(i) Define the term database. (ii) How is it different from a database management system? (b) What is the difference between an entity and an attribute? (c

It defines that the tuple in one relation that refers to another relation must refer to an existing tuple in that relation. This constraint is states on two relations (not essentia

Describe Physical Data independence ? Physical Data Independence - It is capacity to modify the internal schema without having to change conceptual schema. Therefore, the exter

example of embedded SQL query

Objectives differentiate DDBMS and conventional DBMS; Describe Network topology for DDBMS; Describe the concepts of horizontal and vertical fragmentation; Descr