Example of grant create session to mca12, Database Management System

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







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
Related Questions
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

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 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

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? 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 on a relationship type, completeness constraint on generalization.        Ans: Cardinality defines the number of entities to wh

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

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? 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

(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