Results 1 to 4 of 4

Thread: Roles-security

  1. #1
    Join Date
    Aug 2006
    Posts
    39

    Unanswered: Roles-security

    Hi,
    I have added two roles to sql server. One called Officeusers. The other AdminUsers
    Added the appropriate logins to these roles. For example; james, john, ahmad to OfficeUsers and Mat, Nick to AdminUsers.
    How can these roles be now used in a connectionstring? I can use each user login and his relevant password in a connectionstring to connect to sql server but not sure how/where/when the Roles come in to development.
    i.e. do I need to use the role in the connectionstring? if so then what happens to the password.
    Not quite clear about all these.
    Thanks

  2. #2
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Roles are not used in connection strings. They are just ways to group different logins together for assignment of security priveleges.
    You assign all your priveleges to the role instead of assigning every privelege to every user individually.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  3. #3
    Join Date
    Aug 2006
    Posts
    39
    Hi,
    You mean, if there are 10 users in Role1, then I have to go throuogh all the tables permissions to grant for Role1 ?

  4. #4
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    You grant all 10 table permissions to Role1.
    You assign individual users to Role1, so you won't have to grant the 10 table permissions to them individually.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •