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.
| Author |
Topic |
|
YogeshDesai
Posting Yak Master
136 Posts |
 Posted - 2007-09-20 : 08:18:01
|
| Hi Guys, Could you help me to list out all db name and the permissions groups that are active on each database on particular server.SQL IN Minds |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2007-09-20 : 09:38:39
|
| When you say "active" do you mean currently loggen on , or whether the groups have permissions objects? have you checked "sp_helprotect"?Jack Vamvas--------------------Need an IT job ? http://www.ITjobfeed.com |
 |
|
|
YogeshDesai
Posting Yak Master
136 Posts |
Posted - 2007-09-20 : 09:42:40
|
| not currently logged on..need the who have permmisionsSQL IN Minds |
|
|
|
YogeshDesai
Posting Yak Master
136 Posts |
Posted - 2007-09-20 : 11:21:12
|
| opps...... I am using Exec SP_Helplogins and Exec Sp_helpusers, it's quite useful but not expected results, still i am using this for time beingSQL IN Minds |
|
|
|
|
|
|
DB List and permissions