[RESOLVED] SQL Server 2008 - Default Guest Id Question

[Hack]

I received this email from a coworker just a bit ago.

Hi Hack!

How goes life in your area?

Would you have any idea whether we can assign users to the ‘guest’ security group for SQL Server databases? When to go to Security…Users in SSMS I see a guest account. I’d like to use the account whereby I assign read-only privileges and when someone from outside our department needs some kind of read-only access, I could have Security Services assign them to this group. I realize I could create a new security group as well, but thought using an established group might save some time (and this group’s name aptly describes the role!).

Thanks, and hope you’re well!

My unsent response is

“Guest” is not a security group, but a user Id that, like any other user id, belongs to a security group. As such, you can’t assign other user Ids to “Guest”.

[GaryMazzone]

That is correct as far as I know.... I would create an SQL Server Role that is Read Only and assign users to that if you need to.

[Hack]

Thanks!

Coming from you its gospel!