(no subject)

From: Rajesh Dayal <Rajesh_at_ohitelecom.com>
Date: Wed, 21 Mar 2001 23:52:10 -0800
Message-ID: <F001.002D4627.20010321224523@fatcity.com>

You can always do that !!

Grant exp_full_database role to any user and he would be able to perform full export. But...... be aware he would also get following roles/system privileges:

SELECT ANY TABLE
BACKUP ANY TABLE
EXECUTE ANY PROCEDURE
EXECUTE ANY TYPE
EXECUTE_CATALOG_ROLE
SELECT_CATALOG_ROLE.
ADMINISTER RESOURCE MANAGER
INSERT, DELETE, and UPDATE on the tables SYS.INCVID, SYS.INCFIL, and SYS.INCEXP. HTH,
Rajesh
-----Original Message-----
Xing
Sent: Thursday, March 22, 2001 9:56 AM
To: Multiple recipients of list ORACLE-L

Hi,

Can I perform a full export without using System account If I have to create a new user to perform a full export what are the roles
that need to be granted ?

Thank You

Sinardy

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Sinardy Xing
INET: sinardyxing_at_bcsis.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Rajesh Dayal
INET: Rajesh_at_ohitelecom.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------