| Offline backups [message #109479] |
Thu, 24 February 2005 21:02  |
geetar
Messages: 2
Registered: February 2005
Location: Silver Spring, MD
|
Junior Member |
|
|
Is it possible to do an Offline backup without using the 'SYSDBA' privilege ?
Basically, we have a OS authenticated user, who performs the backup. Now, in order to shutdown the database, I have to initiate a connect / as sysdba. If that is the case, I am at risk of exposing all the database objects for updates, deletes privileges to this userid. Is there no alternative available to take an off-line backup without giving sysdba access.
|
|
|
|
| Re: Offline backups [message #109611 is a reply to message #109479] |
Sun, 27 February 2005 04:12  |
Frank Naude
Messages: 4589
Registered: April 1998
|
Senior Member |
|
|
Consider providing SYSOPER instead of SYSDBA access to your backup team. With SYSOPER access, users can startup, shutdown, mount, and dismount instances.
Best regards.
Frank,
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
