SELECT sid, status, name, dbname, hasaccess, loginname FROM master.dbo.syslogins; GO SELECT spid, kpid, lastwaittype, waitresource, dbid FROM master.dbo.sysprocesses; GO...(read more)

You may be aware that a user in a SQL Server 2005 database can only see metadata that the user either owns or on which the user has been granted some permission. A default policy enhanced as compared to how a DBA can control the security access to the database-table level. A better way to prevent unwanted users with minimal privileges from viewing ...