Thanks! It worked
From: Diana M (DianaM@NOJunk.com)
Date: 12/27/02
- Next message: Brian: "Adding Logins"
- Previous message: Josh: "Retrieve the IP Address from a Failed Login Attempt"
- In reply to: Diana M: "Re: jobs in sql server"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
From: "Diana M" <DianaM@NOJunk.com> Date: Fri, 27 Dec 2002 08:31:51 -0800
Yes, you are right. TargetServersRole permission let user
to see jobs.
Thank you very much Tom
>-----Original Message-----
>I meant we have 2 separate jobs. It is same name and it
>runs same SP, but it is 2 separate jobs.
> Yes, I have added the user to db_owner role in msdb and
>he still can not see the job on production server.
> This user is not a member of sysadmin role. Actually I
do
>not want to give sysadmin rights to him, because he does
>not need it. His rights are limited to access to the
>single database on the server and he needs to run this
job.
>
>
>>-----Original Message-----
>>Some possibilities come to mind. Has the user been
added
>to the db_owner role in msdb on the dev box? Has he/she
>been added to the TargetServersRole role in msdb? Is
this
>user a member of a Windows group that has been added to
>the sysadmin role?
>>
>>--
>>Tom
>>
>>---------------------------------------------------------
-
>-----
>>Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
>>SQL Server MVP
>>Columnist, SQL Server Professional
>>Toronto, ON Canada
>>www.pinnaclepublishing.com/sql
>>
>> "Diana M" <DianaM@NoJunk.com> wrote in message
>news:030b01c2adb5$bd108ee0$8af82ecf@TK2MSFTNGXA03...
>> Hello everybody,
>> We have 2 SQL Servers7. One is the development and
>the
>> other is production. Both servers has the same job X.
I
>> have Admin rights and I am the owner of the X job on
>both
>> servers.
>> We have user USER1 on both servers who is not
>> administrator.
>> I am wondering if somebody could explain why USER1
can
>> see the job X on development server, but he can not
see
>it
>> on the production ????
>>
>> Thank you in advance
>> Diana M
>>
>>
>.
>
- Next message: Brian: "Adding Logins"
- Previous message: Josh: "Retrieve the IP Address from a Failed Login Attempt"
- In reply to: Diana M: "Re: jobs in sql server"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
