Privilege

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

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

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