viewing privileges

[TCoughran]

I'm using sp_grantlogin to give login permission to a user group, is there a way to query and see what users/groups have login permission?

Here's what's going on. I'm doing this using SQL Server Scripts in Wise for Windows Installer. I'm not getting an error message, but the command doesn't appear to be working either. So I would like to know how to check the database to see if the usergroup does has login permission. Only MSDE is installed so I can't use the Enterprise manager to find out.

All help appreciated.

Thanks

 

[NathanGriffiths]

sp_helplogins 'DOMAIN\User'

to return info for a particular login, or omit the parameter to return info on all logins.




Nathan


Want to get a good response to your question? Read this FAQ! -> faq183-874