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
What will be create when a primary key if combined with a foreign key? A primary key if combined with a foreign key it creates Parent-Child relationship between the tables that

Properties of a Transaction        A transaction has four main properties. These are: Atomicity Consistency Isolation or Independence Durability or Permanen

Define What are the desirable properties of a decomposition Ans: What are the desirable properties of decomposition - dependency preserving.  Because Lossless join and dependen

Views in relational algebra:   1. Basic expression contains either  a) A relation in the database. b) A constant relation. 2.  General expressions are madde out of sma

Explain outer join? Outer Join - If there are any values in one table which do not have corresponding value(s) in the other, in an equi-join which will not be chosen. Such ro

Domain Constraints Domain constraints are primarily formed for defining the logically correct values for an attribute of a relation. The relation allows attributes of a relatio

Describe five main functions of a database administrator. Ans: A database administrator (DBA) is a person who is accountable for the environmental aspects of a database. Genera

Consider the subsequent relations along with keys underlined Street (name, location, city) House (number, street_name) Lives (name, house_number) Define the above relations

Un-Normalized Form (UNF) If a table having non-atomic values at every row, it is said to be in UNF. An atomic value is something that cannot be further decomposed. A non-atomic

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 pictori