WIN NT: CONNECT INTERNAL without a password
Posted on 1998-08-14
My backup scripts shutdown the database before making a
full offline backup. The problem is that I have to connect
as INTERNAL providing a password but I do not want to let it
written in my scripts (which are supposed to run at midnight
under user Administrator in Windows NT).
Setting DBA_AUTHORIZATION to BYPASS in Windows NT registry
eliminates the need for a password to connect as INTERNAL
(even when there is a password file). I do not want to
let DBA_AUTHORIZATION set to BYPASS all the time, but just
for the duration of the backup. I have tried to set it as an
environmental variable in the backup.bat file, but it did
I know that it is simpler in Unix: if the user running
Server Manager belongs to group DBA there is no obligation
to provide a password for INTERNAL.
So the questions are:
1) Is there any environmental variable which allows to bypass
the password for internal and which can be set from whithin
2) Is there any way to momentarily change the value of
DBA_AUTHORIZATION in the registry without the assistance
of the registry editor?
3) Does Oracle Workgroup Server for Windows NT provide a sort
of "DBA group" feature similar to that in Unix?
Thanks in advance.