Quote:
Originally Posted by timdwells
Unfortunately I am uncomfortable giving that role to individuals in each of the separate locations. I have been able to locate where I believe the specific schema objects are where the roles are delegated, but they don't match up to the listed/useable rights of the existing roles.
So, for the sake of discussion (as I am going to screw with the rights in SQL in the attempt of this because I am still pre-production) has anyone else come across this need/desire and if so what did they attempt.
Thanks
|
I have the same issue. Sr. HelpDesk Admin Role is fine, except they don't have the ability to assign software configurations. I wanted this ability so that whenever they add a new user, that they are able to assign the DST Patch configuration, as that is pretty important I think.
Can you tell me which schema objects you found seem to be doing the delegation?
Also, what are the corresponding Audit roles? What do they have/not have compared to the regular roles?