Allowing a user access to setting up security

Question

Allowing a user access to setting up security

Shark Energy

SSCrazy Eights

Points: 8389
More actions
May 8, 2008 at 4:47 am

#76981

Crazy as it sounds...
What do I need to do to give a SQL User permission to log onto Enterprise Manager and only have access to the security section?
I.e. I want one of my admin staff to add new users and permissions to roles, but not full access to anything else.
Ideas?

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

Jack Corbett SSC Guru Points: 184394 More actions · Answer 1

I don't think you can set it up so they can just see the security section, but you can put them in the fixed server role of securityadmin id you need them to be able to add logins to the server. For the database you could do the fixed server role of db_accessadmin.

Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question