Hi All,
I have an application that Insert, Update and delete some rows in a table of SQL database wchich is to be used by certain specific users within the network(it uses windows authentication to restrict other users).
The table has a column with update login whose default value is SQL login credentials.
Now whenever I update any row from the application the update login feild gets the value of my sql login as it is configured in the connection string in my .net application.
So my question is , is there a way i can store the user name(domain name) of user that is accessing the application in the update login feild of my table.
Thanks for help in advance!!!
I have an application that Insert, Update and delete some rows in a table of SQL database wchich is to be used by certain specific users within the network(it uses windows authentication to restrict other users).
The table has a column with update login whose default value is SQL login credentials.
Now whenever I update any row from the application the update login feild gets the value of my sql login as it is configured in the connection string in my .net application.
So my question is , is there a way i can store the user name(domain name) of user that is accessing the application in the update login feild of my table.
Thanks for help in advance!!!