Re: query to check the rights on tables
From: Alex Filonov <afilonov_at_pro-ns.net>
Date: Wed, 15 Nov 2000 22:25:00 GMT
Message-ID: <8uv2fj$vjg$1_at_nnrp1.deja.com>
role_sys_privs,
role_tab_privs
Date: Wed, 15 Nov 2000 22:25:00 GMT
Message-ID: <8uv2fj$vjg$1_at_nnrp1.deja.com>
In article <8uutqs$rdd$1_at_nnrp1.deja.com>,
Corto Maltese <corto_at_castel.nl> wrote:
> Hi all,
>
> Silly question maybe but I cannot find the right query (tables) to get
> an overvieuw what rights sql+ accounts have on what tables.
> Can someone provide me some clues how to perform this ?
>
> Best regards,
>
> CM.
>
> ps: it's a 10.7 environment.
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
You can look for grant of oracle users and roles in views:
dba_tab_privs, dba_sys_privs, dba_role_privs, role_role_privs,
role_sys_privs,
role_tab_privs
>
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Wed Nov 15 2000 - 23:25:00 CET