Grouping Users for Permissions

• dJeePe

  Say Hey Kid

  Points: 712

  More actions

  April 26, 2007 at 8:39 pm

  #175950

  I am confused.

  Let me describe what I think I should be able to do and tell me if it is possible or not and maybe some directions.

  I have db1, db2, db3, db4 for example.

  I have a group (Group1) in our Organization that only needs select to db1 and db2.

  I have another group (Group2) in our Organization that need read and write to db1 and db3.

  Each user has their own login. How can I group all the users of Group2 and set permissions at the group level not the user level.

• Ameena Lalani-347953

  Old Hand

  Points: 332

  More actions

  April 26, 2007 at 9:16 pm

  #702842

  Please create database roles such as group1 and group2. Add appropriate database users in the respective role and then assign permissions to the roles.

• dJeePe

  Say Hey Kid

  Points: 712

  More actions

  April 27, 2007 at 9:46 am

  #702981

  thanks