Understanding privileges

Any system that allows individual users to be created must also have some form of user access control. This prevents users from accessing or affecting components that should not be available to them. Access control is critical to establishing system security and contributes to the overall health and safety of a computer system. We see examples of access control in everything from operating systems to web mail accounts. In Oracle, we administer access control using a number of methods, the most primary of which is through the use of privileges.

Granting system privileges

The first type of privilege we will examine is a system privilege. System privileges define a class of wide-reaching privileges that affect the ability ...

Get OCA Oracle Database 11g: Database Administration I: A Real-World Certification Guide now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.