to get the user currently logged on to the database

  • Thread starter Thread starter Trainee
  • Start date Start date
T

Trainee

hi

i am using OleDbSchemaGuid.Schemata to return the users logged on to a
database but this method returns all the users but i need to know the user
who is currently logged in to that database is that possible??????

Avinash
 
Hi,

I guess it will be simple to get the username from the connection
string :)
Assuming connection string following same convection

"Provider=.. UID=...Pwd=...."

HTH
Kalpesh
 
This might help if it is in your connectionstring, but what if it is not?
What if there is a Windows authentication?

Sorry, I don't have the answer to that....

Cheers
Christiaan
 
Which DB ? Generally you can use a SQL function that returns the current
user such as CurrentUser in Access or SUSER_SNAME in SQL Server etc...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

OleDbSchema Guid 7
ACCESS database connection error:DB-0053 The maximum number user r 7
How to determine the current user's rights 1
Most Efficient Way to Tell if User is Logged On 2
LINQ-to-SQL Previous values? 7
VB2008: ConnectionString in strongly typed TableAdapter 3
Restricted Users, Shared Database Location 1
MVC Web-API - token based authentication 2

Back
Top