exports, full or otherwise, do not include sys objects... You would have
to recreate them in the target system...

M

>>> "genegurevich"
<oracledba-ezmlmshield-x63607875.[Email address protected] 12/28/04 11:44
AM >>>




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



--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html


Oracle LazyDBA home page