-- Stored Procedure: dbo.whoami -- Bill Wunder use admin GO SET QUOTED_IDENTIFIER ON GO SET ANSI_NULLS ON GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[whoami]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[whoami] GO CREATE PROCEDURE "whoami" as set nocount on select user_id() as "user_id" select suser_id() as "suser_id()" select suser_name() as "suser_name()" select suser_sid() as "suser_sid()" select suser_sname() as "suser_sname()" select user_name() as "user_name()" select user as "user" select system_user as "system user" select current_user as "current_user" select session_user as "session_user" if system_user = 'NT AUTHORITY\ANONYMOUS LOGON' select 'true' as "system_user = 'NT AUTHORITY\ANONOMOUS LOGON'" else select 'false' as "system_user = 'NT AUTHORITY\ANONOMOUS LOGON'" select is_member('Public') as "is_member('Public') default database role" select is_member('BOULDER\Domain Users') as "is_member('BOULDER\Domain Users') domain group" select is_member('customer_service') as "is_member('customer_service') user defined database role" GO SET QUOTED_IDENTIFIER ON GO SET ANSI_NULLS ON GO GRANT EXECUTE ON [dbo].[whoami] TO [public] GO