CurrentUser Not Working

[Dan M]

Access XP project file with SQL Server 2K back end. Using
NT authentication, so existing users can access the db
without a separate login.

Using T-SQL security functions, attempting to determine
current user. I've used Current_User, SUser_SName(),
System_User, User_ID(), User_Name() and they all return
either dbo or sa. All users have user objects and
matching logins.

I simply need to return their actual user name instead of
dbo and sa. Any ideas.

I'm trying to pull their user name in a stored procedure's
output parameter.

CREATE PROCEDURE sp_GetCurrentUser @theUser nvarchar(50) =
Null OUTPUT

AS

SELECT @theUser = User_Name() --(I've used all the above
mentioned functions here.)
SELECT @theUser

 

[John Thomas]

Are you using ADO to pull the output parameter of the
stored procedure? If so, be careful about the connection
you are using for the command object. It is best if you
use a connection object with a trusted connection, and
your command object's activeconnection property is set to
your connection object.

 

[Graham R Seach]

Dan,

Create a Stored Procedure containing the following:

SELECT SUSER_SNAME(SUSER_SID())

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia

Microsoft Access 2003 VBA Programmer's Reference
http://www.wiley.com/WileyCDA/WileyTitle/productCd-0764559036.html