| Privileges required for export [message #533787] |
Thu, 01 December 2011 05:30  |
Database admin
Messages: 365
Registered: September 2006
Location: india
|
Senior Member |
 
|
|
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  |
 |
Michel Cadot
Messages: 68641
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 |
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
