David Emerson
davide at dalyn.co.nz
Fri Jul 2 16:28:48 CDT 2004
I tried this but still got egas\David rather than the group he belongs to. David At 1/07/2004, you wrote: >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 > > >_______________________________________________ >dba-SQLServer mailing list >dba-SQLServer at databaseadvisors.com >http://databaseadvisors.com/mailman/listinfo/dba-sqlserver >http://www.databaseadvisors.com