• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 217
  • Last Modified:

guets account status per DB

is there an easy way to query all databases in an instance, to see if the guest account/role has access?
0
pma111
Asked:
pma111
1 Solution
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
guest is a built-in account, you cannot remove it.
you may want to use scripts like this one to query for what you want to do, adjusting it to check for only the guest user:
http://gallery.technet.microsoft.com/scriptcenter/Get-logins-databases-816f66b2
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now