search

utPLSQL / utPLSQL-v2-v3-migration

utPLSQL v2 to utPLSQL v3 migration utilty and bridge for using utPLSQL v3 framework with utPLSQL v2 Unit Tests
Apache License 2.0
2 stars 1 forks source link

Install executed by SYS fails on 12c #3

Closed jgebal closed 7 years ago

jgebal commented 7 years ago

If there are trusted users that do need to inherit privileges from the DBA user, specific grants can be performed. GRANT INHERIT PRIVILEGES ON USER dba_user TO trusted_user; Following this grant, any invoker rights code owned by TRUSTED_USER can inherit privileges from DBA_USER when the code is called by DBA_USER. You can revoke this specific priviledge as follows. REVOKE INHERIT PRIVILEGES ON USER dba_user FROM trusted_user;

https://oracle-base.com/articles/12c/control-invoker-rights-privileges-for-plsql-code-12cr1