• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 223
  • 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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Python 3 Fundamentals

This course will teach participants about installing and configuring Python, syntax, importing, statements, types, strings, booleans, files, lists, tuples, comprehensions, functions, and classes.

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