Post reply

Grouping Users for Permissions

  • 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.

  • 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.

  • April 27, 2007 at 9:46 am

    #702981

    thanks

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

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