Re: SQL Server role members

From: Baisong Wei[MSFT] (v-baiwei_at_online.microsoft.com)
Date: 04/16/04 

Date: Fri, 16 Apr 2004 05:49:48 GMT

Hi Jakob,

Thanks for the update. Well, I take a test on my machine and did not
re-produce the problem. Could you follow my steps and try again, I log in
my computer as system administrator:
1) I create some windows account, my machine name is BAIWEI:
BAIWEI\test1
BAIWEI\test2
BAIWEI\test3
2) I create a windows group BAIWEI\testgroup, and add the above three
account in this windows group
3) In the SQL Enterprise Manager, I only add this windows group
BAIWEI\testgroup as a SQL Server login
4) Then, in SQL Enterprise Manager, in the pubs database, I add this SQL
login BAIWEI\testgroup as the database user.
5) Then in the pubs database, I created a database role 'groupmember' and
only add this database user 'BAIWEI\testgroup' in this role, all the other
settings are default.
6) I log off and again log in my computer with account 'test1'.
7) In the Query Analyzer, I run the following T-SQL:
    select is_member('groupmember')
I got 1.

As IS_MEMBER() Indicates whether the current user is a member of the
specified Microsoft Windows NT group or Microsoft SQL Server role. I run
select is_member('BAIWEI\testgroup')
I got 1too.

Could you take the exact above steps and check if you got the same results?
Looking forward to your reply.

Best regards

Baisong Wei
Microsoft Online Support
----------------------------------------------------
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only. Thanks.

Relevant Pages

  • Re: SQL Server role members
    ... > 2) I create a windows group BAIWEI\testgroup, ... > 4) Then, in SQL Enterprise Manager, in the pubs database, I add this SQL ... > login BAIWEI\testgroup as the database user. ... > specified Microsoft Windows NT group or Microsoft SQL Server role. ...
    (microsoft.public.sqlserver.security)
  • Re: Managing SQL database rights using AD
    ... logins to SQL Server. ... You would add these two logins you ... just added as users in the database. ... the Windows group that you just added as logins (and then ...
    (microsoft.public.sqlserver.security)
  • RE: Permissions not saved
    ... exist in the current database. ... account that is part of the System Admin server role, ... you registered SQL Server in SQL Enterprise Manager with an account that is ... Please let me know what role the account holds within SQL Server. ...
    (microsoft.public.sqlserver.security)
  • Re: NT Autentication for Windows groups
    ... Create a database role for each group of users. ... easier to manage if the group of users were in a Windows Group. ... Looking for a SQL Server replication book? ...
    (microsoft.public.sqlserver.server)
  • Re: Need help on how to organize users and objects
    ... Security is a huge subject in SQL Server 2005, so I'd suggest you to spend ... Create two Windows Group (Dev and Viewers) ... database A and 6-9 tables in Database B you can assign explicity GRANT ...
    (microsoft.public.sqlserver.security)
Loading