RE: User rights

From: Ian Cary (C) <Ian.Cary_at_ordnancesurvey.co.uk>
Date: Fri, 29 Apr 2005 13:51:31 +0100
Message-ID: <AB4FD5014A06414688019F9244194C66DED964@EXCHMSA.ordsvy.gov.uk>

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

Received on Fri Apr 29 2005 - 08:56:15 CDT