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.
[EMAIL PROTECTED]
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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).