Oranew
asked on
Oracle sys tables access to users with dba role
I am trying to create account for some users with the dba role. After creating the accounts the dba role users can't able to access sys objects. Is there some specific role for the sys objects so that the dba role users can have all access.? I tried to grant sysdba but it error out as we are not maintaining password file.
ANy suggestions like init.ora parameters etc?
ANy suggestions like init.ora parameters etc?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Great ! Granting "select any dictionary" worked and it solves the problem.
I have another question now. How can the dba role user be able to access without putting the sys.(dot)
example not sys.user$ but user$ only. ( We don't create sys object synonyms manually).
Is this something can be done ?
I have another question now. How can the dba role user be able to access without putting the sys.(dot)
example not sys.user$ but user$ only. ( We don't create sys object synonyms manually).
Is this something can be done ?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Yes, I agree with you.
Also note SELECT ANY DICTIONARY is NOT sufficient to read every dictionary table in 12c
In particular, SELECT ANY DICTIONARY does NOT grant access to sys.user$
In particular, SELECT ANY DICTIONARY does NOT grant access to sys.user$
catalog.sql
catproc.sql
I also assume, but also please verify, that you granted the DBA role to the account you're using as DEFAULT. It's possible to create and to assign a ROLE, that will require manual enabling.