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 |
|
Blin
Starting Member
36 Posts |
 Posted - 2004-10-28 : 18:47:16
|
| Hi there,I'd like to produce a list of all users with their permissions/system roles (dbowner, ddladmin, dbreader, dbwriter, etc.) Any system tables or sp_ procedures will allow me to do so? or any ways to achieve it?Secondly, how do I dertermine if user logins have not been used for a long time thus can be removed from the system?Thanks. |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2004-10-28 : 19:12:59
|
| sp_helpuser and sp_helprolemember will give you info. Login usage is a little tougher, but you should be able to glean some information from the SQL Server error logs regarding login attempts/successes/failures. |
 |
|
|
Blin
Starting Member
36 Posts |
Posted - 2004-10-28 : 21:30:57
|
| Thanks. I'm new to SQL Server. Where and how can I get error logs info regarding login attempts/success/failures? Can I get it from EM? |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2004-10-28 : 22:43:40
|
quote:
Originally posted by Blin
Thanks. I'm new to SQL Server. Where and how can I get error logs info regarding login attempts/success/failures? Can I get it from EM?
yes, if you've set your server to log this.under enterprise manager, expand the server instance folder, then goto management, then sql server logs, the file is also saved just in case you want to keep a copy. btw, this log will get larger unless you have a schedule when to truncate.--------------------keeping it simple... |
|
|
|
|
|
|
|
|
Login and Permissions