Unable to GRANT dba to user
681054Jul 27 2009 — edited Jul 27 2009Hi,
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.