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 |
|
yourz
Starting Member
1 Post |
 Posted - 2013-03-12 : 10:18:56
|
Hi...I need a t-sql script for SQL SERVER 2005Requirements:I have 2 user accounts for the both accounts i need to find the all the permissions.Like...The 2 users are mapped to which databases on the server?What are the databases names? What kind of permissions having on the mapped databases?For each database i need to find all the permissions like object level, schema level....etc.....? Thanks |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2013-03-12 : 12:44:25
|
| have a look atsp_helploginsandsp_helpuser |
 |
|
|
|
|
|
Schema, Object Level Permissions for a user