Rookie Question On User Permissions

[jerm]

I am running SQL 7.0 on Win 2000 and when I go into Enterprise Manager and then into my database and then to Users, Some of my users have "Permit" under the Database Access column but other users have a "Via group membership" under it.  I know that I can add the ones that say "Permit" by simple right-clicking and adding them but I was wondering how the ones with "Via group membership" got in there? Thanks for the help.

 

[MapMan]

SQL Server has two ways off Granting/Revoking/Denying access to a user.&nbsp;&nbsp;ROLES & USERS<br><br>When you create a user, you must assign them to a group.&nbsp;&nbsp;Most new users are added to public.&nbsp;&nbsp;By doing so, they inherit what ever permissions that group(ROLE) has.<br><br>Later on, or right away, depending on your environment, you may want to DENY/REVOKE a privelege to a certain user.&nbsp;&nbsp;To do so, you select whatever object you want to DENY/REVOKE them access to and select the option box until you see a red &quot;X&quot;.<br><br>So, in short, the &quot;Via Group Membership&quot; means that a group(ROLE) that the user belongs to has been granted access to that object AND the user has not explicitly been GRANTED/REVOKED/DENIED access to that object.<br><br>HTH,<br><br>Mapman

 

[jerm]

Thanks for the help but that still does not tell me how the Users with &quot;Via Group Membership&quot; in the Database Access column were added.&nbsp;&nbsp;It must be an automatic process because I have not found a way to add Users with &quot;Via Group Membership&quot; manually.&nbsp;&nbsp;I can only manually add the Users that have the word &quot;Permit&quot; under the Database Access column. I don't know how it works exactly, maybe it's through the groups defined in Win 2000, I don't know?