March 22, 2006 at 10:41 am
I have a job setup within a server thats running SQL Server 2000 Enterprise
Edition with all the current service packs.
The job in SQL Agent services two different user groups that want to be able
to submit the job on demand or review the jobs status.
Both SQL authentication and windows authentication are enabled on the server.
I'm looking for a way where both domain or both individual SQL ID's can get
in and do what they need to do with the job but it appears the job can only
have one owner. The other use can't see it.
When I create a windows group containing those individual domain ID's, the
job doesn't appear to want to recognize the group ID.
Tried a single purpose login SQL ID for them and too often confused them and
gave rise to other security and auditing issues.
Any ideas on how to handle or what I might be missing?
thks
March 23, 2006 at 8:44 am
You may want to look at this discussions:
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=189454
|
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=6&messageid=6668
execute permission on sp_start_job for non-sysadmi
Regards,Yelena Varsha
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply