PL/SQL (MOSC)

MOSC Banner

Test about the newly introduced "INHERIT PRIVILEGES" privilege in oracle 12c

edited Dec 27, 2013 5:54AM in PL/SQL (MOSC) 1 commentAnswered
"INHERIT PRIVILEGES" privilege is a new privilege introduced in oracle 12c. Database security guide told us that:
In "GRANT INHERIT PRIVILEGES ON USER  invoking_user  TO procedure_owner" statement
invoking_user  is the user who runs the invoker’s rights procedure. This user must be a database user account.
procedure_owner  is the user who owns the invoker’s rights procedure. This value must be a database user account.
As an alternative to granting the INHERIT PRIVILEGES  privilege to the procedure's owner, you can grant the privilege to a role that is in turn granted to the procedure.

I try to prove what oracle said. So i do the following tests.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center