Post reply

Security

  • December 13, 2007 at 10:30 pm

    #95693

    Hi I have a security question. Let's say I know that we can create a login group. In the same way can we even create user group, I mean to ask lets say for a particular we have more than one user with the same rights , is this possible that we can group those two users in a single group and give rights to that group.

    Thanks in advance.

  • December 14, 2007 at 1:48 am

    #760102

    Yes, you can do this. Two possible ways

    Option 1. Create a windows group, add the users to the windows group, create a login for the windows group in sql server, give database access to the login. This will make the windows group a user in your database and you can then grant permissions.

    Option 2: Create logins for each user, grant database access to your database. In your DB create a new database role and add both users to the role. Then grant permissions to the role.

    Hope this helps

    [font="Verdana"]Markus Bohse[/font]

  • December 14, 2007 at 8:45 am

    #760294

    Whether you use #1 listed by Markus or not, you should always use roles.

    do not assign rights to users. Sooner or later they will quit, someone else will do their job, something. Assign all rights to roles and add users to roles. Even a role of one makes sense.

  • December 14, 2007 at 8:48 am

    #760296

    Thank YOu gusy. I appreciate your help:)

Viewing 4 posts - 1 through 3 (of 3 total)

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