How to check the Permission of Group in SQL Server

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

How to check the Permission of Group in SQL Server

Author

Topic

sqldba_ind
Starting Member

22 Posts

Posted - 2007-10-29 : 08:46:29

Hi all

How to check the Permission of a group(Read/write) on Databases using SQL query.

Thanks&Regards
SUSRI

sqldba_ind
Starting Member

22 Posts

Posted - 2007-10-29 : 09:35:24

Hi all

I have a group in SQL Server,I need to find out One what databases the Gruop having read/write Permission.

Please help me.

Thanks&Regards
SUSRI

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-10-29 : 23:18:34

You mean windows group that added as sql login? Try sp_helplogin.

sqldba_ind
Starting Member

22 Posts

Posted - 2007-10-31 : 11:39:26

Yes your correct,

But what are logins in that group.

ex:some body(sysadmin) created DevelopGrp in that group how many user are there I want see using query analyzier.

Thanks&Regards
SUSRI

elancaster
A very urgent SQL Yakette

1208 Posts

Posted - 2007-10-31 : 11:46:29

or maybe sp_helprolemember ?

Em

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-10-31 : 23:42:01

xp_logininfo 'nt group name','MEMBERS' will return all members in that group.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources