Oracle Configuration

purpose in oracle, the objective is to create a user who can connect to the database (create session), view metadata and dictionary information, perform select operations on any table grant permissions oracle session creation privilege grant create session to \[ username ]; \ metadata view permissions grant select catalog role to \[ username ]; \ select permission on all tables grant select any table to \[ username ]; \ select permission on all dictionary objects grant select any dictionary to \[ username ]; verify system privileges oracle 1 select s privilege as sys priv , r granted role as role priv , t privilege as tab priv from ( select privilege from dba sys privs where grantee = ’\[ username ]’) s left join ( select granted role from dba role privs where grantee = ’\[ username ]’) r on 1=1 left join ( select privilege from dba tab privs where grantee = ’\[ username ]’) t on 1=1;