Oracle system privilege

<<Previous  Next>>

Oracle system privilege - Feb 14, 2009 at 15:00 PM by Amit Satpute

SYSTEM PRIVILEGE

A system privilege is the right to perform an action on any schema objects of a particular type.

Like, the privileges to create tablespaces and to delete the rows of any table in a database are system privileges.

There are over 60 distinct system privileges.

Any Privilege

System privileges that use the ANY keyword enable you to set privileges for an entire category of objects in the database. PUBLIC privileges are granted to every user in an Oracle database, and can be granted to roles and as users.

The answers to following questions will be made available soon. Keep visiting.

Explain the system privilege categories i.e. user privileges, developer privileges, “any” privileges, database maintenance, monitoring privileges.

Use of Roles in oracle

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..........

What are the different Levels of Auditing? Explain them

Statement Auditing, Privilege Auditing, and Object Auditing...........

Define Statement Auditing, Privilege Auditing and Object Auditing in oracle.

Statement auditing is the auditing of the powerful system privileges without regard to specifically named objects.............

What is a profile in oracle?

A profile is assigned to each database user that states its limitation on various system resources...........

<<Previous  Next>>