Orphan SQL-Server accounts
By using SP_MSForEachDB you can detect and display orphan SQL-Server accounts from all the databases of your SQL-Server.
EXEC SP_MSForEachDB 'USE [?];
-- SYSTEM DATABASE ARE EXCLUDED
IF DB_ID(''?'') > 4
SELECT ''?'' as DBName,
name AS UserName,
sid AS UserSID
FROM .sysusers
WHERE issqluser = 1 AND
(
sid IS NOT NULL AND sid <> 0x0
)
AND suser_sname(sid) IS NULL
ORDER BY name'
CU
tosc
| Print article | This entry was posted by Torsten Schuessler on 2008-04-18 at 14:20:05 . Follow any responses to this post through RSS 2.0. |
No feedback yet
Leave a comment
Trackback address for this post
http://www.insidesql.org/blogs/htsrv/trackback.php?tb_id=183
Schlagwort-Wolke
backup «best practices» books «case study» ctp «cumulative update» datetime dmv ebook exams faq humor index indexoptimize integrity kb learning links loginproperty maintenance «ms sql server 2008» mysql performance php profiler «reporting services» reports reviews serverproperty «service pack» «service pack 3» sharepoint sp_msforeachdb «sql 2008» «sql pass» «sql server» «sql server 2005» «sql server 2008 r2» «sql server builds» sqlcat «sqlpass franken» sqlsrv ssms ssmstoolspack t-sql «technical note» tools training troubleshooting whitepapers




