Posted by traceable1 on 04/03/07 20:50

I have users that need to schedule jobs (SQL 2000, SP4). They can
create jobs, but can only see the core databases when they go to enter
a step (master,msdb,Northwind,tempdb, pubs).

The users have db_reader and db_writer on other databases - why won't
they come up? I can't give the users dbo or sysadmin.

thanks for any insight!
tracy

• Next in forum: Re: SQL query help
• Prev in forum: SQL query help
• Thread view: User rights for creating Scheduled Jobs

[Reply to this message]