Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

We've just started using oracle edition-based redefinition, which is a great feature.

One DB user can run the following command without problems, and another will get ORA-01031:

grant use on edition my_edition to public

What privileges must a user have to run this command?

I've given the user the following :

alter user &user enable editions;  
grant create any edition to &user;
grant alter edition to &user;
grant use on edition my_edition to &user;

What am I missing?

share|improve this question
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.