Re: SQL Server role members

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

Date: Fri, 16 Apr 2004 14:55:32 GMT

Hi Jakob,

Thanks for you update. One thing I should confirm is that, the user you
login into your system and run the is_member() should NOT be the system
administrator of the SQL Server, that is, it should not belong to the
sysadmin server role.

Also, could you please provide the following information:
use master
go
select * from syslogins
select * from sysxlogins
use pubs
go
select * from sysmembers
select * from sysusers
exec sp_helprolemember
exec sp_helpuser

Looking forward to your reply. Thanks.

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: Security hole?
    ... > WSS FAQ at wss.collutions.com ... > added to the site he does not even see this workspace in the list of all ... > also removed that login from sysadmin server role. ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: Import Logins from text or spreadsheet
    ... set psw to generic value ... add user to database ... EXEC sp_addrolemember 'SomeRole', 'SomeLogin' ... Let's assume your Excel spreadsheet has 3 columns: Login, ...
    (microsoft.public.sqlserver.server)
  • Re: Import Logins from text or spreadsheet
    ... Good suggestion, Steve. ... EXEC sp_addlogin $, $, $(Database) ... EXEC sp_addrolemember $, $(Login) ...
    (microsoft.public.sqlserver.server)
  • Re: dbo association
    ... The dbo user is a special case; database ownership determines the login ... EXEC sp_changedbowner 'MyLogin' ...
    (microsoft.public.sqlserver.security)
  • Re: Using osql.exe to set account permissions?
    ... To accomplish mentioned tasks one may do the following: ... EXEC sp_defaultdb 'Domain\UserName', 'box_LM_W3SVC_1_Collab' ... > Create a New Login ... > Permit database access for that login to that database ...
    (microsoft.public.sqlserver.security)