Example-GRANT CREATE SESSION TO MCA12;

(This command gives system level permission on creating a session - not portable)

GRANT SELECT ON EMP TO MCA12;

(Object level permission on table EMP)

GRANT SELECT, UPDATE, INSERT, DELETE ON EMP TO MCA12;

GRANT SELECT, UPDATE ON EMP TO MCA12, MCA13;

(Two users)

GRANT ALL ON EMP TO PUBLIC;

(All permission to every users, do not use it. It is very risky for database)

Revoke: It is used to revoke the permission granted.

 

 

Posted Date: 3/11/2013 1:16:51 AM | Location : United States

Ask an Expert

Related Discussions:- Example of grant create session to mca12, Assignment Help, Ask Question on Example of grant create session to mca12, Get Answer, Expert's Help, Example of grant create session to mca12 Discussions

Write discussion on Example of grant create session to mca12
Your posts are moderated

Write your message here..

Related Questions

Datawarehouse, 1) Define a job scheduling strategy that will meet business ... 1) Define a job scheduling strategy that will meet business requirement of reporting availability by 6am CST for the following cubes? Show the job scheduling dependencies in a pict

Data base design for a museum information system, In this practical assignm... In this practical assignment, we will run through a complete database application development cycle, starting with the schema design, from an initial data import to database applic

Which are two ways that entities participate relationship, Which are the tw... Which are the two ways in which entities can participate in a relationship? Total and partial are the two ways in which entities can participate in a relationship

B2b business uk database, We have a new website where I need someone to 1: ... We have a new website where I need someone to 1: Inhabit the back end with all the recruitment agencies in the UK. I require someone who is not manually going to do this, but who w

Explain the log based recovery method, Explain the Log Based Recovery Metho... Explain the Log Based Recovery Method? The system log that is generally written on stable storage consists of the redundant data required to recover from volatile storage failu

Define cardinality and participation constraints, Define cardinality and pa... Define cardinality and participation constraints on a relationship type, completeness constraint on generalization.        Ans: Cardinality defines the number of entities to wh

Map an E-R diagram to a relational schema, I need to Map an E-R diagram to ... I need to Map an E-R diagram to a relational schema

Explain the concept of deadlock, Explain the concept of deadlock Yes. I... Explain the concept of deadlock Yes. It can direct to deadlock. Suppose that a batch of frames arrived correctly and were accepted. Then receiver will advance its window. Now s

How can you start mysql server, How can you Start MySQL Server? To star... How can you Start MySQL Server? To start the mysql program type it is name in the command- line prompt. After starting mysql program just display A welcome letter using the

What is a sub-query, (a) What is a Sub-Query? (b) What is the differen... (a) What is a Sub-Query? (b) What is the difference between a scalar sub-query and a tabular sub-query? (c) Write an equivalent SQL statement to get the Name of Product wh