Bill, This one is much easier on W2K than on NT. There exists a RunAs Service on W2K. Last time I checked on WinNT Server 4.0, I couldn't switch the authority of the Schedule service from LocalSystem to another user. But you may still be able to get a "connect / as sysdba" to work. In the WinNT 4 Resource Kit, there is an su.exe command. I don't have NT4 at home - will have to look it up in the office tomorrow. <man_page> - W2K Pro Runas Allows a user to run specific tools and programs with different permissions than the user's current logon provides. It is good practice for administrators to use an account with restrictive permissions to perform routine, nonadministrative tasks, and to use an account with broader permissions only when performing specific administrative tasks. To accomplish this without logging off and back on, log on with a regular user account and use the runas command to run the tools that require the broader permissions. runas [/profile] [/env] [/netonly] /user:UserAccountName program Parameters /profile Specifies the name of the user's profile, if it needs to be loaded. /env Specifies that the current network environment be used instead of the user's local environment. /netonly Indicates that the user information specified is for remote access only. /user:UserAccountName Specifies the name of the user account under which to run the program. The user account format should be user@domain or domain\user. program Specifies the program or command to run using the account specified in /user. For examples of the use of the runas command starting other Windows 2000 commands, see Related Topics. </man_page> Paul Bill Wagman wrote: > > Hello, > > I am running several batch jobs against an 6.1.6.3.0 database on NT using > the WinAT scheduler to schedule these jobs. Is it possible to set them up > so to run as a particular user, oracle for example, so I don't have to > embed passwords in my command files? > > Thanks. > > Bill Wagman > Univ. of California at Davis > Information Resources > [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Drake 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).
