In an Oracle 18.104.22.168 database I have a user with DBA as the default role. But I had to grant explicitly via "grant SELECT on ..." to this user to allow it to select from DBA_ROLE_PRIVS and DBA_USERS. Since the DBA role grants all system privileges WITH ADMIN OPTION, why is it necessary to grant separately "select on DBA_USERS and on DBA_ROLE_PRIVS" to this user? This was not needed under Oracle 22.214.171.124.
May 19, 2004 10:49 AM
May 20, 2004 8:44 AM