RE: Backup Control File Privilege

From: Paul Baumgartel <PaulB_at_instipro.com>
Date: Tue, 05 Jun 2001 11:22:15 -0700
Message-ID: <F001.0031C7DF.20010605110657@fatcity.com>

Since the syntax of the command to do this is

alter database backup controlfile to trace;

you must grant "alter database" privilege.

Paul Baumgartel
InstiPro Group, Inc.
paul.baumgartel_at_instipro.com
212 813-0829 x103

-----Original Message-----
Sent: Tuesday, June 05, 2001 2:13 PM
To: Multiple recipients of list ORACLE-L

I am trying to grant a user the privilege to backup the control file to trace. I cant seem to find a system privilege that does this. I have run

select distinct privilege from dba_sys_privs

but cant see a privilege to backup the control file. Can anyone tell me where I might find the complete list of system privileges?

Thanks.
Erik

--

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

Author: Erik Williams
INET: ewilliams_at_brownco.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: Paul Baumgartel
INET: PaulB_at_instipro.com

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