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

Explain the togaf framework for enterprise architectures, Question: (a)... Question: (a) With the help of a diagram, explain the TOGAF framework for enterprise architectures. (b) Where would you position enterprise architectures in an enterpri

What are the advantages of having an index structure, What are the advantag... What are the advantages of having an index structure?      Ans: The index structures commonly provide secondary access paths, which offer alternative ways of accessing the reco

What do you mean by atomicity and aggregation, What do you mean by atomicit... What do you mean by atomicity and aggregation? Atomicity : Either all actions are carried out or none are. Users should not have to worry about the effect of incomplete trans

What are ways of finding out derived attributes, What are ways of finding o... What are ways of finding out either an update is required or not for derived attributes? The ways to find out an update is required or, not are as: Explicit update

Development of large scale distributed real systems, Question: (a) What... Question: (a) What are the challenges in the development of Large Scale Distributed Real Systems? (b) What is backward engineering and forward engineering in a design packa

Relational algebra, Consider the relation schemas as follows. works (per... Consider the relation schemas as follows. works (person name, company name, salary); lives (person name, street, city); located in(company name, city); managers (person name

Decomposition.., explain concept of decomposition? explain concept of decomposition?

What are the components of storage manager, What are the components of stor... What are the components of storage manager? The storage manager components include a) Authorization and integrity manager b) Transaction manager c) Buffer manager d

Central database schema, Consider an information system designed for an onl... Consider an information system designed for an online company which provides IT products and services. These include desktops, laptops, networking products, IT books, parts, and te

Availability-data replication, Availability: A site having the copy of a r... Availability: A site having the copy of a replicated relation fails, even then the relation may be found in another site. Therefore, the system may carry on to process at least th