11.2.0.4 Edition based redefinition problem : can revoke use on edition only by SYS
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;