If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > MySQL > user authentication and tracking

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 08-24-04, 13:21
bonito bonito is offline
Registered User
 
Join Date: Jun 2004
Posts: 30
user authentication and tracking

I have a microsoft access database and recently migrated the tables to mysql, its working very nicely, but I migrated it largely because I figured it to be more secure a database than access and that it would be faster. Now I want to add user tracking and authentication features to the database. I am a bit of a newbie to any database work, and am taking this one step at a time, and I was hoping someone could give me some links to tutorials or howtos on how you would implement these types of features. The things I am looking to do with it are:

-User login screen
-Record login information to a table each time the user logs in
-Store who creates a record, and who modifies it
-Create a form for the user to log the amount of time taken to perform a given task, having their name as the only option for the user name on the form...writing the data to a table of course.

I have a good idea as to what the table structure would be for all the things I would need to do, but the programming and how to create a login and store the username logged in and write that information to a table, its a problem. Can someone point me in the right direction?
Reply With Quote
  #2 (permalink)  
Old 08-28-04, 07:42
simkeechai simkeechai is offline
Registered User
 
Join Date: Aug 2004
Posts: 3
Cool

I am not sure this would help.
if i were you, i would start the mysql server with "--log-update" option, because with this command, you could keep track of what the user has been done to the server.
Reply With Quote
  #3 (permalink)  
Old 08-30-04, 09:35
gvphubli gvphubli is offline
Registered User
 
Join Date: Sep 2003
Location: United States
Posts: 53
This is a programming issue..what language did u use while the database was in access ?...b'cos MySql has no GUI tools like what MS-Access has. So if you choose to use VBA (MS-Access) or VB or any other language ...then in that case you have to use SQL statements to insert/update your database tables. If you want to know how to develop such application i would recommend you visit planet-source-code.com and search for DB application samples.
__________________
Girish Patil
10+ Yrs of SQL Server Dev & Admin Exp.
ITIL Foundation Certified
Visit my blog : http://gvphubli.*************/
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On