sql server new users: SQL Job Access Rights -- sql server new users

Re: SQL Job Access Rights

Sue Hoegemeier
5/22/2006 1:40:13 PM

How you address that really depends on what version of SQL
Server. Is this SQL Server 2005 or SQL Server 2000 (or
lower)

-Sue

On Fri, 19 May 2006 22:43:19 -0500, "Mail"
[quoted text, click to view]

Re: SQL Job Access Rights

Mo
5/22/2006 9:36:59 PM

Do you guyz know what rights are needed to run a SQL job (SQL Server 2000)?

I have a friend that took away SA rights to a user and that user has dbo
access to the database, but can't run the job anymore.

What I think it is, they don want to give full SA rights back to the user.

Any suggestions or leads?

Thankz
Mo
[quoted text, click to view]

Re: SQL Job Access Rights

Sue Hoegemeier
5/24/2006 11:52:58 AM

Then the user would need to be the owner of the job. In SQL
Server 2000, if a user is not a sysadmin then they can only
view and execute jobs that they own.

-Sue

On Mon, 22 May 2006 21:36:59 -0500, "Mo" <moone@charter.net>
[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server new users group.