Detecting secureables in SQL 2005/2008

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: "msnews.microsoft.com" <neilw@xxxxxxxxxx>
Date: Mon, 8 Jun 2009 19:28:12 -0400

It is easy to run a query to see which logins, if any are in the sysadmin
role.

But how do you detect logins that have been granted effective permission to
"View Any Database" via the "Securables" Login Property? Is there a query
for that in SQL 2005/2008?

Thanks.

.

Follow-Ups:
- RE: Detecting secureables in SQL 2005/2008
  - From: Linchi Shea

Prev by Date: Re: Compare data in two tables
Next by Date: Re: Using NOT IN in table field
Previous by thread: How do I NOT round numbers up?
Next by thread: RE: Detecting secureables in SQL 2005/2008
Index(es):
- Date
- Thread

Relevant Pages

Re: SA can not create users
... If you're absolutely sure that the registration is using a sysadmin ... account, then I have no idea why you can't create logins. ... And since you can manage logins from QA ... Prev by Date: ...
(comp.databases.ms-sqlserver)
Re: Databases not showing up in Enterprise Manager
... > HAS_DBACCESS function to show/hide databases any database listed by ... > the query below should be listed and available to the user. ... When I run it from one of the logins ... SQL Server is terminating this process. ...
(comp.databases.ms-sqlserver)
Re: object level permissions being lost when migrating
... I am talking about SQL Logins, ... can go to the object and see that user X has permissions XYZ on that object, ... I then restored the databases and re-synched the users via the ...
(microsoft.public.sqlserver.security)
Re: object level permissions being lost when migrating
... Just want to confirm that you are talking about SQL Logins and not windows Logins correct? ... As far as I know the compatibility level should not be an issue one way or the other but exactly how are you looking at the permissions? ... I first transferred the logins from the 2000 server to the 2005 server via ...
(microsoft.public.sqlserver.security)
Re: Logging in irrespective of database access
... Try connecting using Query Analyzer with one of the problem logins and run ... the following in the context of your demodata and accounts databases: ... This will return the security context used to access the database. ... SQL Server MVP ...
(microsoft.public.sqlserver.server)