Home » RDBMS Server » Security » about exp_full_database (Oracle 10.2.0.4.0, RedHatLinux-5)
about exp_full_database [message #592964] Tue, 13 August 2013 06:13 Go to next message
8939513598$
Messages: 103
Registered: July 2013
Location: chennai
Senior Member
Hi All, Is there any Role where 'exp_full_database' role is contained in it? or it is compulsory to grant to the user for exporting objects.,

Re: about exp_full_database [message #592965 is a reply to message #592964] Tue, 13 August 2013 06:14 Go to previous messageGo to next message
8939513598$
Messages: 103
Registered: July 2013
Location: chennai
Senior Member
Hi All, Is there any Role where 'exp_full_database' role is contained in it? or it is compulsory to mention grant exp_full_database to the user for exporting objects.
Re: about exp_full_database [message #592984 is a reply to message #592964] Tue, 13 August 2013 08:08 Go to previous message
Michel Cadot
Messages: 59427
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
1/ Yes, query dba_role_privs
2/ No need of exp_full_export to export your data

Regards
Michel
Previous Topic: v$pwfile_users
Next Topic: DBUSER rights and role
Goto Forum:
  


Current Time: Sat Oct 25 13:34:50 CDT 2014

Total time taken to generate the page: 0.13198 seconds