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 |
|
steelkilt
Constraint Violating Yak Guru
255 Posts |
 Posted - 2004-07-21 : 10:24:36
|
| Hi, I've just found out that all of my users (me included)are being migrated to a new domain.I use SQL Server 7.0 on NT 2000 Server. I want to get ahead of the game if possible and get the new accounts added to resources while the old accounts are still active.Is there a script of some sort that would allow me to list all SQL Server 7.0 resources a specific user has permissions to?thanks! |
|
|
JasonGoff
Posting Yak Master
158 Posts |
Posted - 2004-07-22 : 05:09:01
|
This will give you some idea of who has permissions to what in each database (by no means complete !)select u.name as [User],o.name as [object],p.*from sysobjects oinner join syspermissions p on o.id=p.idinner join sysusers u on u.uid=p.grantee |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2004-07-22 : 05:36:33
|
| This is probably a master..sysLogins problem, rather than a database..sysUsers problem isn't it?I'll shut up now because I don't know how to do this!Kristen |
|
|
|
|
|
|
domain migration imminent -- how to list users?