PL/SQL (MOSC)

MOSC Banner

11.2.0.4 Edition based redefinition problem : can revoke use on edition only by SYS

edited Jul 17, 2019 6:45AM in PL/SQL (MOSC) 2 commentsAnswered

Hello

Documentation has as an example

revoke use on edition ORA$BASE from public;

but if you execute it not as SYS , you'll get ORA-01927 cannot revoke privileges you did not grant

For new edition , it is possible to grant/revoke use on edition, but after the edition has been database default for a while , it may be "retired" ( doc term) only by SYS.It's not good

example :

-- create user

create user test_ee identified by test_ee;

grant connect,resource to test_ee;

grant create view to test_ee;

grant alter database to test_ee;

grant select any dictionary to test_ee;

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