permission to review jobs and settings

From: Joshua Heslinga (hes01@co.henrico.va.us)
Date: 08/28/02 

From: "Joshua Heslinga" <hes01@co.henrico.va.us>
Date: Wed, 28 Aug 2002 13:17:38 -0400

I have some co-workers within my IT department where I'd like to be able to
give them the ability to view, but not change, a variety of SQL Server 2000
settings. In general, outside of tables and objects within databases, it
seems to me that SQL doesn't support a reviewer/read-only permission style.
Does this observation match other people's experience?

To be a little more specific, there are 2 things I'd like to allow them to
do:

1) view the settings and status of backup jobs-- I've been unable to find a
way for people other than the sysadmins and job owners to view this
information. Is there a role or permission I can grant for a person to be
able to view the jobs other than to make them a sysadmin?

2) view the access rights and properties of logins -- Again, I can't seem to
find a read-only kind of permission here, just the ability to make somone a
security admin or system admin, which then gives them the ability to change
too. Is there a role or permission for this?

Please pardon me if these are dumb questions.

Thank you.

Relevant Pages

  • [PATCH 5/6] Enhance SELinux control of executable mappings
    ... This patch for 2.6.10-rc2-mm4 adds new permission checks to the SELinux mmap and mprotect ... hooks to enable control over the ability to make executable a mapping ... The task->self execmem permission controls the ...
    (Linux-Kernel)
  • Re: Neowin News: "Rare mac trojan exploits apple vulnerability"
    ... The wikipedia article agrees with what I said: ... The read permission, which grants the ability to read a file. ... this permission grants the ability to read the names ...
    (comp.sys.mac.system)
  • Re: changing permissions in windows XP using ruby!!
    ... On non-Posix operating systems, there may be only the ability to ... make a file read-only or read-write. ... permission bits will be synthesized to resemble typical values. ...
    (comp.lang.ruby)
  • Reset Password
    ... I would like to facilitate the ability for a group of ... users that are given permission to change passwords for ... regular users to be able to do so through some sort of Web ...
    (microsoft.public.win2000.security)