Re: Grant user to see the SQL Server job status
From: capitanou (capitanou.1q4k63_at_mail.mcse.ms)
Date: 06/04/05
- Previous message: Dan Guzman: "Re: modifying database permissions"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Sat, 4 Jun 2005 08:42:02 -0500
Add the user to the RepositoryUser role in msdb. This is a new role
added in sp3. users must have this role in order to view the staus of
jobs
Swami wrote:
> *Hi
>
> I need to grant permission to the user to see the sql server job
> status
> through Enterprise Manager. I did the following steps but still
> these users
> are not able to see the sql server jobs status. Even few jobs are
> running
> these users always shows as " not running" .
>
> 1 Created a separate role to in MSDB to monitor daily sql servers
> jobs. In
> this role granted target server roles and execute permission to few
> stored
> procs which the user can start and stop .
>
> 2 I dont want to give sysadmin rights to these users.
>
> Need your info
>
> Regards
>
> Swami *
-- capitanou ------------------------------------------------------------------------ Posted via http://www.mcse.ms ------------------------------------------------------------------------ View this thread: http://www.mcse.ms/message1631364.html
- Previous message: Dan Guzman: "Re: modifying database permissions"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
|
