OraFAQ Forum: Server Administration » EXP_FULL

Home » RDBMS Server » Server Administration » EXP_FULL_DATABASE role (Oracle , 10.2.0.4.0 , Sun solaris)

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

EXP_FULL_DATABASE role [message #535257]

Tue, 13 December 2011 04:14

Jack14
Messages: 497
Registered: December 2011
Location: INDIA

Senior Member

Hi,

Can anybody list out the activities that the user could perform with the help of EXP_FULL_DATABASE role
other than export?

Thank you

Report message to a moderator

Re: EXP_FULL_DATABASE role [message #535261 is a reply to message #535257]

Tue, 13 December 2011 05:04

Michel Cadot
Messages: 68770
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

It has no other purpose than this, don't use it for anything else.
What is your actual issue?

Regards
Michel

Report message to a moderator

Re: EXP_FULL_DATABASE role [message #535274 is a reply to message #535261]

Tue, 13 December 2011 05:52

Jack14
Messages: 497
Registered: December 2011
Location: INDIA

Senior Member

Hi Michel,

Thank you for your responds.

Actually just want to know the impact of this role.

The exp_full_database role can perform multiple schemas export at one time which would save time
else we have to go schema by schema export.This is what i know on export for exp_full_database role.

Report message to a moderator

Re: EXP_FULL_DATABASE role [message #535277 is a reply to message #535274]

Tue, 13 December 2011 06:15

Michel Cadot
Messages: 68770
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Yes, this is true.
What was the purpose of your first question?
Is it a concern about the privileges that grant this role?
Indeed, this role must be done only to trusted account and, in my opinion, its action should be audited.

Regards
Michel

Report message to a moderator

Re: EXP_FULL_DATABASE role [message #535288 is a reply to message #535277]

Tue, 13 December 2011 06:37

Jack14
Messages: 497
Registered: December 2011
Location: INDIA

Senior Member

Michel

<What was the purpose of your first question?
Is it a concern about the privileges that grant this role?

Just wanted to know what the user could do with the help of role.

Thank you

Report message to a moderator

Re: EXP_FULL_DATABASE role [message #535291 is a reply to message #535288]

Tue, 13 December 2011 06:49

Michel Cadot
Messages: 68770
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

So many things (that most likely depends on the version).
In 10.2.0.4, it has (plus some object privileges):

EXECUTE_CATALOG_ROLE                      
SELECT_CATALOG_ROLE                       
ADMINISTER RESOURCE MANAGER               
BACKUP ANY TABLE                          
EXECUTE ANY PROCEDURE                     
EXECUTE ANY TYPE                          
READ ANY FILE GROUP                       
RESUMABLE                                 
SELECT ANY SEQUENCE                       
SELECT ANY TABLE

It is a very powerful role that should be very seldomly given.

Regards
Michel

Report message to a moderator

Re: EXP_FULL_DATABASE role [message #535300 is a reply to message #535291]

Tue, 13 December 2011 07:17

Jack14
Messages: 497
Registered: December 2011
Location: INDIA

Senior Member

Thank you so much Michel for your answer.

Report message to a moderator

Previous Topic:	Tablespace fragmentation in 10g
Next Topic:	Pulling data from a db that NO ONE has a password to

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Oct 10 21:04:19 CDT 2025