O'Reilly logo

Oracle Database Administration: The Essential Refe by Brian Laskey, David C. Kreines

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Roles

Roles are the mechanism used by Oracle to facilitate the granting of system and object privileges to users. The granting of roles is a three-step process:

  1. The role is created by someone with the CREATE ROLE system privilege.

  2. System or object privileges are granted to the role by anyone with the proper authorization.

  3. The role is granted to a user by anyone who has the GRANT ANY ROLE system privilege, or by anyone who has been granted the role via the WITH ADMIN OPTION.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required