Hi all:

I have a role called MDB_ABINITIO to which I have granted select on some
SYS. tables. I can see
all these tables when I run the following query:

1 select a.role,
2 b.granted_role || decode(admin_option,'YES',' (With Admin
Option)',null) || ' - ROLE' what_granted
3 from sys.dba_roles a, sys.role_role_privs b
4 where a.role = b.role
5 and a.role like upper('%&&1%')
6 UNION
7 select a.role,
8 b.privilege || decode(admin_option,'YES',' (With Admin
Option)',null)
9 what_granted
10 from sys.dba_roles a, sys.dba_sys_privs b
11 where a.role = b.grantee
12 and role like upper('%&&1%')
13 UNION
14 select a.role,
15 b.owner || '.' || b.table_name || ' - ' || b.privilege
16 || decode(grantable,'YES',' (With Grant Option)',null)
what_granted
17 from sys.dba_roles a, sys.dba_tab_privs b
18 where a.role = b.grantee
19 and role like upper('%&&1%')
20* order by 1

(where &&1 is the name of the role). But when I do a full database export
with grants=y and rows=no, I do not see
any grant select to MDB_ABINITIO in the dump file. I have done it a few
times under different IDs, but all with the
same result. Does any one know why is this happenning?

thank you

Gene Gurevich


Oracle LazyDBA home page