Comments for Edition Based Redefinition in Oracle Database 11g Release 2
Vladimir said...Thanks, a nice description.
Unfortunately Oracle made the feature sometimes inconsistent. Suppose you made possible for SCOTT to create editions:
grant create any edition, drop any edition to scott;
Then SCOTT creates some edition:
CREATE EDITION some_edition;
From now, SCOTT can enable edition SOME_EDITION in his session.
But if you revoke CREATE ANY EDITION and DROP any EDITION from SCOTT, the ability to enable/disable of SOME_EDITION by SCOTT remains !
I didn't find any place in the data dictionary indicating this relation of SOME_EDITION to SCOTT, formally not existing !
Gary Pennington said...Your UNIX/Linux examples are not correct.
$ sqlplus username/password@service edition=ora$base
The "$base" part will be translated by the shell, so
you would need to something special to stop it.
For example single quotes 'ora$base' or escape it as in ora\$base
Thanks for pointing that out. I've corrected the typo in both places now.
Jacek said...Hey Tim.
Great Article and a nice description of a feature.
Would be nice to give it a try.
Thank you for spending time to prepare and share it.
DO NOT ask technical questions here! They will be deleted!
These comments should relate to the contents of a specific article. Constructive criticism is good. Advertising and offensive comments are bad and will be deleted!