If Abinitio is fully qualifying references to the sys. tables
then you will have to rememebr to recreates the grants.
But if the tables are not being fully qualified, you could create a view
that Abinitio could access.

It just depends on where the pain is.

Godd luck. :-)

-----Original Message-----
From: Michael Porter
[mailto:oracledba-ezmlmshield-x73565652.[Email address protected]
Sent: Tuesday, December 28, 2004 11:11 AM
To: LazyDBA Discussion
Subject: Re: can't see a role in an export dump


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



--------
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