Home » SQL & PL/SQL » SQL & PL/SQL » local system logon as sysdba
local system logon as sysdba [message #191437] Wed, 06 September 2006 06:36 Go to next message
patrick
Messages: 83
Registered: December 2000
Member
I have a batch job like the following

sqlplus /nolog @start.sql
in the start.sql script it sys the following
connect / as sysdba

When i start it as an administrator works ok.

When i schedule it it is automatically started as local system and then i get insufficient priviliges. I don't want to have it run under administrator or any other account then the local system.

I also don't want to put in the sys password in the sqlscript. I know it is possible because we have it working on another server but we lost the knowledge of how.
Operating system is windows server 2003

Thanks
Re: local system logon as sysdba [message #191452 is a reply to message #191437] Wed, 06 September 2006 07:16 Go to previous messageGo to next message
aorehek
Messages: 52
Registered: August 2006
Member
Grant ora_dba group to local user in your os environment.
Re: local system logon as sysdba [message #191457 is a reply to message #191437] Wed, 06 September 2006 07:27 Go to previous messageGo to next message
patrick
Messages: 83
Registered: December 2000
Member
local system is a built-in account in windows and you cannot assign it to a group.

Re: local system logon as sysdba [message #192047 is a reply to message #191437] Sun, 10 September 2006 08:46 Go to previous messageGo to next message
markmal
Messages: 113
Registered: April 2006
Location: Toronto, Canada
Senior Member
specify the job to run using account that is in ORA_DBA group.
Re: local system logon as sysdba [message #192122 is a reply to message #192047] Mon, 11 September 2006 01:38 Go to previous message
patrick
Messages: 83
Registered: December 2000
Member
Well we didn't want that so we solved the problem with the oradim options in the scrip. Thanks for all the help everybody

Previous Topic: Max Simultaneous Users
Next Topic: how to know whether an update or insert happened due to an insert or update statement
Goto Forum:
  


Current Time: Wed Dec 07 03:10:08 CST 2016

Total time taken to generate the page: 0.10781 seconds