Test about the newly introduced "INHERIT PRIVILEGES" privilege in oracle 12c
"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.
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.
0