How to define a current user?

Posted by ie on Stack Overflow See other posts from Stack Overflow or by ie
Published on 2010-05-10T15:09:28Z Indexed on 2010/05/10 15:14 UTC
Read the original article Hit count: 141

Filed under:

advantage-database-server

|

system-procedures

Is it possible to define a current user?

I found a stored procedure 'sp_mgGetConnectedUsers'. It returns a result set with the only unique field 'Address'. How could I associate an executing query with such 'Address'.

Please advice.

Note: As far as I understand, another way to get the current user is to set a unique application Id for each connection, but I don't like this way much.

© Stack Overflow or respective owner

Related posts about advantage-database-server

Transferring data from Advantage Database Server to SQL Server

as seen on Stack Overflow - Search for 'Stack Overflow'
My client is using Advantage Database Server and wants to move to SQL Server but obviously wants to move all his clients data as part of the upgrade over to SQL Server. I've thought about writing an app to do the transfer but thinking it might be more trouble than its worth. What would you recommend… >>> More
Using the .NET Entity Framework with the Advantage Database Server

as seen on Internet.com - Search for 'Internet.com'
Learn how to use Microsoft's .NET Entity Framework to connect to, consume and update an Advantage database. >>> More
Using the .NET Entity Framework with the Advantage Database Server

as seen on Internet.com - Search for 'Internet.com'
Learn how to use Microsoft's .NET Entity Framework to connect to, consume and update an Advantage database. >>> More
Using the .NET Entity Framework with the Advantage Database Server

as seen on Internet.com - Search for 'Internet.com'
Learn how to use Microsoft's .NET Entity Framework to connect to, consume and update an Advantage database. >>> More
Using SQL Server Analysis Services with Sybase Advantage Database Server

as seen on Stack Overflow - Search for 'Stack Overflow'
Is it possible to use SQL Server 2008 Analysis Services with data stored in Sybase Advantage Database Server? Either directly, or via SQL Server Integration Services. >>> More

Related posts about system-procedures

How to define a current user?

as seen on Stack Overflow - Search for 'Stack Overflow'
Is it possible to define a current user? I found a stored procedure 'sp_mgGetConnectedUsers'. It returns a result set with the only unique field 'Address'. How could I associate an executing query with such 'Address'. Please advice. Note: As far as I understand, another way to get the current… >>> More
HSSFS Part 3: SQL Saturday is Awesome! And DEFAULT_DOMAIN(), and how I found it

as seen on SQL Team - Search for 'SQL Team'
Just a quick post I should've done yesterday but I was recovering from SQL Saturday #48 in Columbia, SC, where I went to some really excellent sessions by some very smart experts. If you have not yet attended a SQL Saturday, or its been more than 1 month since you last did, SIGN UP NOW! While searching… >>> More
T-SQL Tuesday #33: Trick Shots: Undocumented, Underdocumented, and Unknown Conspiracies!

as seen on SQL Team - Search for 'SQL Team'
Mike Fal (b | t) is hosting this month's T-SQL Tuesday on Trick Shots. I love this choice because I've been preoccupied with sneaky/tricky/evil SQL Server stuff for a long time and have been presenting on it for the past year. Mike's directives were "Show us a cool trick or process you developed…It… >>> More