Skip to Main Content

Oracle Database Express Edition (XE)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Unable to GRANT dba to user

681054Jul 27 2009 — edited Jul 27 2009
Hi,
Using oracle 10g I am facing problem and I do not know what I have done to my database.
When I create user while logon as SYSTEM and I want to grant dba to that user I am getting this message that 'No such role exit'. When I see under roles I can see only two roles
1. AQ_Administrator_Role
2 MGMT_USER

No other roles are seen. Please help me how I can get back all roles and preveliges for system and for sys also as same is the case with sys.
Thanks.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 24 2009
Added on Jul 27 2009
3 comments
2,138 views