Home » RDBMS Server » Server Utilities » granting export rights
granting export rights [message #250035] Sat, 07 July 2007 03:23 Go to next message
hishamshahbaz
Messages: 3
Registered: June 2007
Junior Member
I want to give full export rights to a user so that I can use it for an export of the entire database.
I am using the following command but it gives an error:

grant export full database to <username>;

it gives the ORA-00990 error. How should I fix this?
Re: granting export rights [message #250041 is a reply to message #250035] Sat, 07 July 2007 03:40 Go to previous messageGo to next message
Michel Cadot
Messages: 64140
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
The privilege/role is EXP_FULL_DATABASE.

Regards
Michel
Re: granting export rights [message #250043 is a reply to message #250035] Sat, 07 July 2007 04:36 Go to previous messageGo to next message
abshrestha
Messages: 5
Registered: April 2005
Location: Kathmandu, Nepal
Junior Member

Please Grant as follows:
grant EXP_FULL_DATABASE to <username>;
Re: granting export rights [message #250051 is a reply to message #250043] Sat, 07 July 2007 07:30 Go to previous messageGo to next message
Michel Cadot
Messages: 64140
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Hmm, pretty good answer one hour after mine. Frown

Regards
Michel

[Updated on: Thu, 19 July 2007 08:31]

Report message to a moderator

Re: granting export rights [message #252626 is a reply to message #250051] Thu, 19 July 2007 08:07 Go to previous message
hishamshahbaz
Messages: 3
Registered: June 2007
Junior Member
Thanks both of you Razz
Previous Topic: Partial Import
Next Topic: SQL Loader Control File - User Name / User ID : How to get it
Goto Forum:
  


Current Time: Fri Dec 09 09:57:13 CST 2016

Total time taken to generate the page: 0.13330 seconds