how to locate the user name of an application

[curiousvbnet]

Hi,

i have created an application and i want to know which user has used the application.

Do i have to create a new field in each table of the db to insert inside the user name( the one who has inserted a data in the concerned table )or is there another way to locate the user who has used the application.
It is clear taht before entering in the application the user has to enter its login + password.
Perhaps can i do something at this level.
Thanks a lot for your help.

Regards
Nathalie

 

[SgtJarrow]

In a Windows environment where the users are logging into a domain, you can use My.User.Name to capture the Windows NT Name of the user. Just add one field to your table and include the above to your insert to record the name of the person related to the record.

=======================================
People think it must be fun to be a super genius, but they don't realize how hard it is to put up with all the idiots in the world. (Calvin from Calvin And Hobbs)

Robert L. Johnson III
CCNA, CCDA, MCSA, CNA, Net+, A+, CHDP
VB/Access Programmer

 

[computerjin]

If you are managing application specific users, roles, rights and privileges in your application and you want to handle control based security (column and row based security in terms of databases) then the following article will definitely help you out. Check it.

http://www.simple-talk.com/dotnet/w...ased-security-in-a-windows-forms-application/

It's a tedious task but you can do it with thorough study and spending a good time in front of your computer.

Hope it will help you.