NT: RE: Re: How to get jobs under WinAT to run as Oracle

Here's an untested hunch.

create the batch file that you want to run. create an NT service for the batch file. in the services applet, modify the properties for the service to run as a user belonging to the local group ORA_DBA. schedule the service to run.
see if it succeeds or fails.

hth,

Paul

-----Original Message-----
Sent: Thursday, April 12, 2001 2:35 AM
To: ORACLE-L_at_fatcity.com
Cc: Paul Drake

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_at_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
> wjwagman_at_ucdavis.edu

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Paul Drake
  INET: drake_at_psscorp.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).