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
Describe the different RAID levels.  Discuss the choices of the different RAID levels for different applications.          Ans:   There are several combinations of these approa

Create a Student database and Retrieve the names of all students majoring in ‘CS' Consider the following relational database: STUDENT (name, student#, class, major) COURSE (co

What is nested relational model? The nested relational model is an extension of relational model in which domains might be either atomic or relation valued.

Sequential File Organisation The most necessary way to organise the collection of records in a file is to use sequential Organisation. Records of the file are stored in series

One-to-many : An entity in A is related with any number of entities in B. An entity in B is related with at the most one entity in A. Example: Relationship between faculty and d

Which is an advantage of view? The Advantages of view is Data security, Derived columns and Hiding of complex queries

What is the use of unique function? UNIQUE function: If UNIQUE is specified then only unique values are used to computed the mean.

Sparse and Dense Indexes These indexes in principle are the similar as that of indexes used at the back of the book. The key facts of the indexes are: They are arranged

Run the following queries. For each query show 1) What you expect the output to be based upon the data 2) the SQL code and 3) the output running the query in Oracle. 1. Show all c

Explain the differences between structured data and unstructured data. Structured data are facts concerning objects and events. The most significant structured data are numeric