<<Previous Next>>
Oracle - Explain how to
grant DML privilege on a table - Feb 23, 2010 at 11:00
PM by Rajmeet Ghai
Explain how to grant DML privilege on a table.
Privilege in Oracle is used to allow or give rights to a
particular user to execute a SQL query. Priveleges in oracle are
granted using the GRANT command.
Example:
GRANT select ON table_name TO user_name
A system privilege is the right to perform an action on any
schema objects of a particular type.............
Roles in Oracle can be used to grant privileges to a specific
group of users for security. The database manager is usually
responsible for granting privileges to a Role..........
Statement Auditing, Privilege Auditing, and Object
Auditing...........
Statement auditing is the auditing of the powerful system
privileges without regard to specifically named
objects..............
| 
