Privileges required for export [message #533787] |
Thu, 01 December 2011 05:30 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
Database admin
Messages: 365 Registered: September 2006 Location: india
|
Senior Member |
![bala_mech2004](/forum/theme/orafaq/images/yahoo.png) ![fgdgs](/forum/theme/orafaq/images/jabber.png)
|
|
Hi,
I have one question regarding privileges required for export.
I read in a document that
Quote:
If you do not have the system privileges contained in the EXP_FULL_DATABASE role,
you cannot export objects contained in another user's schema. For example,
you cannot export a table in another user's schema, even if you created a synonym for it.
My question is... what are the system privileges required in EXP_FULL_DATABASE role
to perform export objects contained in another users schema?
Thanks
[Updated on: Thu, 01 December 2011 05:34] Report message to a moderator
|
|
|
Re: Privileges required for export [message #533792 is a reply to message #533787] |
Thu, 01 December 2011 05:40 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68664 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
This is a predefined role, you do not need to know what's inside it.
The role itself is necessary not only the privileges inside it.
Just make a test, copy all privileges into one of your own role and you will still not be able to do the export.
Regards
Michel
[Edit: missing word]
[Updated on: Thu, 01 December 2011 05:45] Report message to a moderator
|
|
|
|