Post reply

Security Help

  • July 6, 2006 at 4:53 pm

    #91139

    Hi, I need to implement a new security level, almost all users are sysadmin. The goal is to remove logins from sysadmin server role and  grant database level access.

    Some other logins need´s to make inserts, updates but others only to select the information in some databases.

    Whats is the best way to do this?

     

  • July 7, 2006 at 7:33 am

    #647969

    The best way to manage this is through roles.  Determine all of the different types of access needed.  Then, create a role for each type of access.  Once you have the roles created, assign the appropriate user(s)s to the appropriate role(s).

    Hope that helps.

    Have a good day,

    Norene Malaney

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

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