Re: Privileges Reporting SQL problem on 7.3.4.1 for Dynix 4.5.1. Numa_Q

From: Alex Filonov <afilonov_at_pro-ns.net>
Date: Thu, 16 Nov 2000 18:15:09 GMT
Message-ID: <8v1874$nu7$1_at_nnrp1.deja.com>


Try this:
select grantee || ' can ' || privilege || ' '|| owner || '.' ||

       table_name || ' thanks to ' || grantor from sys.dba_tab_privs

What do you need union for?

In article <8v01ro$sfb$1_at_guinness.serv.psi.calva.net>,   "Jean-Benoit MORLA" <jean-benoit.morla_at_creditlyonnais.fr> wrote:
> Hello world,
>
> I need this SELECT from the mischievious dba_tab_privs, identifying
 user or
> role
> (May be at the time koch was architect)
>
> GRANTEE yields user/role || ' can ' || PRIVILEGE yields privilege list
 OWNER
> yields owner || '.' || TABLE_NAME yields object || ' thanks to ' ||
> GRANTOR yields user/role.
>
> I'm stuck at GRANTOR level.
>
> I already have 2 selects, union.
>
> Hey, maybe I should try union all?
>
> Or L3G? (Then would you rowid me to the dbms_output.formator package?)
>
> Brainstormers welcome
>
> jean-benoit.morla_at_creditlyonnais.fr
>
> Cc:
>
> jbmorla_at_calva.net
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Nov 16 2000 - 19:15:09 CET

Original text of this message