[dba-SQLServer] Finding current login group

Have you tried:      EXECUTE sp_who       in the SQL Query Analyser?

	-----Original Message----- 
	From: David Emerson [mailto:davide at dalyn.co.nz] 
	Sent: Thu 7/1/2004 5:11 PM 
	To: dba-SQLServer at databaseadvisors.com 
	Cc: 
	Subject: [dba-SQLServer] Finding current login group
	
	

	SQL2000
	
	I am using Windows Authentication.  I have set up Windows groups that users
	belong to.  These groups are set up in SQL as logins (this means that new
	users just need to be added to the windows group to be given access to all
	the databases with permissions for the group).
	
	Within my ADP I need to find out what login the user has accessed the SQL
	database from so that I can show/hide controls etc.  However, when I use
	the CURRENT_USER variable in a Sproc it returns the user, not the group
	they have come in by.
	
	EG - egas\David is a member of egas\BillingUsers Group.  egas\BillingUsers
	is set up as a login in SQL (egas\David is not).  When egas\David is using
	a database he has accessed it because he is a member of
	egas\BillingUsers.  Is there a way to find out the login that was used for
	egas\David to get in (CURRENT_USER returns egas\David, I want
	egas\BillingUsers)?
	
	Regards
	
	David Emerson
	Dalyn Software Ltd
	25 Cunliffe St, Churton Park
	Wellington, New Zealand
	Ph/Fax (04) 478-7456
	Mobile 027-280-9348
	
	_______________________________________________
	dba-SQLServer mailing list
	dba-SQLServer at databaseadvisors.com
	http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
	http://www.databaseadvisors.com