OraFAQ Forum: Server Utilities » granting export rights

Home » RDBMS Server » Server Utilities » granting export rights

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

granting export rights [message #250035]

Sat, 07 July 2007 03:23

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?

Report message to a moderator

Re: granting export rights [message #250041 is a reply to message #250035]

Sat, 07 July 2007 03:40

Michel Cadot
Messages: 68664
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

The privilege/role is EXP_FULL_DATABASE.

Regards
Michel

Report message to a moderator

Re: granting export rights [message #250043 is a reply to message #250035]

Sat, 07 July 2007 04:36

abshrestha
Messages: 5
Registered: April 2005
Location: Kathmandu, Nepal

Junior Member

Please Grant as follows:
grant EXP_FULL_DATABASE to <username>;

Report message to a moderator

Re: granting export rights [message #250051 is a reply to message #250043]

Sat, 07 July 2007 07:30

Michel Cadot
Messages: 68664
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Hmm, pretty good answer one hour after mine. Frown

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

hishamshahbaz
Messages: 3
Registered: June 2007

Junior Member

Thanks both of you Razz

Razz

Report message to a moderator

Previous Topic:	Partial Import
Next Topic:	SQL Loader Control File - User Name / User ID : How to get it

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Jun 22 22:07:02 CDT 2024