
Signature
Thank you,
Daniel Jameson
SQL Server DBA
Children's Oncology Group
www.childrensoncologygroup.org
OK,
I figured it out. This returns the name of every database where the "guest"
user has been activated (GRANT CONNECT):
use master
exec dbo.sp_MSforeachdb '
use [?]
select DB_NAME() + ''.'' + permission_name
from sys.database_permissions
where grantee_principal_id = DATABASE_PRINCIPAL_ID(''guest'')
and permission_name = ''CONNECT'''

Signature
Thank you,
Daniel Jameson
SQL Server DBA
Children's Oncology Group
www.childrensoncologygroup.org
> Hi,
>
> How do I, in SQL 2005, determine for a database whether the guest user has
> been GRANTed CONNECT?