Privileges Reporting SQL problem on 7.3.4.1 for Dynix 4.5.1. Numa_Q

[Quoted] Hello world,

I need this SELECT from the mischievious dba_tab_privs, identifying user or role
[Quoted] (May be at the time koch was architect)

GRANTEE yields user/role || ' can ' || PRIVILEGE yields privilege list OWNER [Quoted] 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 Received on Thu Nov 16 2000 - 08:23:51 CET