470,590 Members | 2,616 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,590 developers. It's quick & easy.

Finding Login Name for a Group Login

Our system administrator set up an NT server group in order to allow
our users to login to our application via https to our sql server.
The group appears as a User in SQL Server when you look at it in
Enterprise Manager. That said, I can not see the users associated
with the group from Enterprise Manager, but know they can login to the
database.
The problem is this. When we login via the web we get access to the
database without problem, but when you look at the current_user what
you see is the login Name the user entered and NOT the name of the
group/User. That is to say, I can see a UserID which is not listed as
a User in SQL Server and can't see the name of the group, which is
listed as a user in SQL Server.
I need to know who's logging in order to direct them to the
appropriate web page via their role. Before the admin set up the
group, I was using sp_helpuser to get the role, but then again I had
the userID to do this.
The question I have now, is there any way to see what the
group/user is who logged in i.e. the goup listed as the User in
Enterprise Manager? Otherwise I have to build a table of userIDs and
their group/User name, which seems to defeat the purpose of having he
server authenticate users.

Thanks,
Tom
Nov 12 '05 #1
0 1069

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by koolyio | last post: by
2 posts views Thread by Steve | last post: by
2 posts views Thread by Tom Loach | last post: by
5 posts views Thread by owyn | last post: by
2 posts views Thread by Shakun | last post: by
reply views Thread by U S Contractors Offering Service A Non-profit | last post: by
4 posts views Thread by Brett | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.