Privilege

From Oracle FAQ
Jump to: navigation, search

A privilege is a special right or permission granted to a user or a role to perform specific actions. Granted privileges can be revoked when necessary. For example, one must grant the CREATE SESSION privilege to a database user before that user is allowed to login. Likewise, the CREATE TABLE privilege is required before a user can create new database tables.

Examples[edit]

Grant a system privilege:

GRANT create table TO scott;

Grant an object privilege:

GRANT select ON emp TO public;

Grant roles to user scott:

GRANT connect, resource, dba TO scott;

Grant other user the right to execute a procedure or function:

GRANT execute ON myproc TO scott;

Also see[edit]

  • role - grouping of privileges
Glossary of Terms
A B C D E F G H I J K L M N O P Q R S T U V W X Y Z #