Adding NT Groups Question

[mgid]

I'm adding NT Groups Users to SQL Server 7 and I have a question about the security access levels. When I add a new user and specify NT, the options under security are "Grant Access" and "Deny Access". However, a user created by one of our vendors has an additional option "Via group membership" selected under security access. I can't find anything about this third option in any documentation, books online, etc. and I can't get this option to appear when adding new users, or on any of our other sql server installs.

Does anyone anything about this third option?

Thanks.

 

[RickCole]

The reason for seeing "Via group membership" on my own SQL servers is the following:

1) User is a member of an NT group, which has access to the server.

2) User creates an object i.e. Stored Procedure, Table etc.

3) As the user is now the owner of that object the "Via group membership" appears.

It does no harm to delete this entry as long as the User is still included in the NT group. However it will re-appear next time they create something.

What Microsoft would call a feature.

Rick.

 

[mgid]

Thank you.