RE: User rights

I'm not entirely sure I understood the question right but I think you are a=
fter select on DBA_TAB_PRIVS and also DBA_ROLE_PRIVS (in case the privilege=
 has been granted through a role.

Hopefully something like

(as sys)

grant select on DBA_TAB_PRIVS to <admin_user>
grant select on DBA_ROLE_PRIVS to <admin_user>=20

(as the admin user where &1 is the user whose permissions you want to  chec=
k)

select owner,
       table_name,
       privilege
from   dba_tab_privs
where  grantee =3D '&1'
or     grantee in (select granted_role from dba_role_privs where grantee =
=3D '&1')
order by 1,2,3

will give you what you want

Cheers,

Ian


This email is only intended for the person to whom it is addressed and may =
contain confidential information. If you have received this email in error,=
 please notify the sender and delete this email which must not be copied, d=
istributed or disclosed to any other person.
Unless stated otherwise, the contents of this email are personal to the wri=
ter and do not represent the official view of Ordnance Survey. Nor can any =
contract be formed on Ordnance Survey's behalf via email. We reserve the ri=
ght to monitor emails and attachments without prior notice.

Thank you for your cooperation.

Ordnance Survey
Romsey Road
Southampton SO16 4GU
Tel: 023 8079 2000
http://www.ordnancesurvey.co.uk

--
http://www.freelists.org/webpage/oracle-l

Other related posts: