please help.--3rd post. 2nd one lost in cyberspace--at least i cannot see it.

[S.L.NARASIMHAM]

i have set up two user accounts on my system running xp.one in my name with
administrative privileges and one in my niece's name with only user
privileges.
i have set some services to start by manual method. ( for example oracle TNS
listener and database)
they can be started by me and i can run sql but when my niece( the primary
user of oracle) logs on in her profile, the same batch file doesnot allow
her to start the services saying access denied.
she has to log into my profile to work on oracle.
i donot want to give her the privileges as administrator because she is
inexperienced and might mess up the whole thing.
suggestions for a work around please.
TIA.
S.L.Narasimham.

 

[norm]

right click on shortcut ,properties,advanced,choose run as
different credentials.

 

[Vagabond Software]

There are a few things we can try.

First, logged in as yourself or Administrator, go to Start-All
Programs-<Your Oracle App> and right-click it, then select Properties from
the pop-up menu. Go to the Security tab and add your daughter to the
permitted users.

I hope that works...

- carl

 

[S.L.NARASIMHAM]

no it doesnot work that way.
i'll try to be clearer.
i have downloaded and installed oracle.
i have 2 user profiles listed as already mentioned.
oracle had installed several services listed in services.msc
since the system was taking a long time to boot, i disabled all of them thru
services.msc and set two services to be start ed manually in a batch file
which i run when i need to run sql plus.
this bactch file runs well in my user profile and since these two services
are started, i can run sql.
if i log out without closing these services , my niece logging on in her
profile can run sql plus.
if she boots and logs into her profile, she cannot run sql as the batch file
doesnot work --giving a system error--access denied message for the two
commands listed in the batch file.
so it is a question of starting these two services in her profile by running
this batch file.
none of the options suggested by the group are available to me in this
file's properties.
the batch file goes like this.

<net start OracleOraHome92TNSListener

net start OracleServicePADMA504
pause> ( the <> added by me now &here)
waiting for enlightenment.
S.L.Narasimham.

 

[Jim Carlock]

What about using the RUNAS command inside of the batch
file to run the services. This will allow the services to run with
Administrative options but it will also mean that if she opens
and reads that file rather than run's it, she'll be able to see
administrative passwords.

RunAs is an executable file found in the Windows\System32
folder, as runas.exe.

Typing runas at the command prompt will give you the options
for using it.

Let me know if that helps at all.

--
Jim Carlock
http://www.microcosmotalk.com/
Post replies to the newsgroup.


no it doesnot work that way.
i'll try to be clearer.
i have downloaded and installed oracle.
i have 2 user profiles listed as already mentioned.
oracle had installed several services listed in services.msc
since the system was taking a long time to boot, i disabled all of them thru
services.msc and set two services to be start ed manually in a batch file
which i run when i need to run sql plus.
this bactch file runs well in my user profile and since these two services
are started, i can run sql.
if i log out without closing these services , my niece logging on in her
profile can run sql plus.
if she boots and logs into her profile, she cannot run sql as the batch file
doesnot work --giving a system error--access denied message for the two
commands listed in the batch file.
so it is a question of starting these two services in her profile by running
this batch file.
none of the options suggested by the group are available to me in this
file's properties.
the batch file goes like this.

<net start OracleOraHome92TNSListener

net start OracleServicePADMA504
pause> ( the <> added by me now &here)
waiting for enlightenment.
S.L.Narasimham.

 

[S.L.NARASIMHAM]

too complicated for me. this computer is a standalone computer and not part
of a domain, so what do i do for the username part? anyway since she finds
it just a little annoyance to log on as me, start the service and then log
off and relogin in her profile, i think i'll let sleeping dogs lie rather
than get into trouble attempting the unknown.. thanks to you all good folk
who helped me.
S.L.Narasimham.

 

[Jim Carlock]

I tried to get some old DOS tricks to work, but I failed. Doesn't
seem like redirection operators work with the RunAs command.

And the RunAs command doesn't seem to be able to use the
/savecreds switch to save the credentials.

I'm at a loss.

--
Jim Carlock
http://www.microcosmotalk.com/
Post replies to the newsgroup.


too complicated for me. this computer is a standalone computer and not part
of a domain, so what do i do for the username part? anyway since she finds
it just a little annoyance to log on as me, start the service and then log
off and relogin in her profile, i think i'll let sleeping dogs lie rather
than get into trouble attempting the unknown.. thanks to you all good folk
who helped me.
S.L.Narasimham.