3 messages in com.mysql.lists.javaRE: authentication| From | Sent On | Attachments |
|---|---|---|
| Kevin Fonner | 09 May 2001 15:10 | |
| Artigas, Ricardo Y. | 09 May 2001 17:28 | |
| Daevid Vincent | 12 May 2001 11:25 |
| Subject: | RE: authentication![]() |
|---|---|
| From: | Artigas, Ricardo Y. (ry...@easycall.net.ph) |
| Date: | 05/09/2001 05:28:54 PM |
| List: | com.mysql.lists.java |
I don't think it's advisable to modify mysql's user table. Although you can use it for authentication. Just make your program try to connect to mysql using the user's username and password. If access was denied then username / password is unauthorized but if the volume of users whos' going to use mysql is very large, then that would not be advisable. You can just create another database and a users table for that purpose and use connection pooling or a fixed connection to mysql and query your own users table to authenticate users. Hope this helps.
:^) "A chain is only as strong as its weakest link." Ricky Y. Artigas Analyst/Programmer Information Technology Division Easycall Communications Phils., Inc. - Easycall Internet - 418 Arayat St., Mandaluyong City 1550, Philippines Personal WAP Site: http://www.buzzed.co.uk/mobile/?rya Company Website: http://www.easycall.com.ph Tel.no: (+632) 5338001 ext.6574 Mobile:(+63) 0917-8951783 Pager: 141-002955 Email: ry...@easycall.net.ph
------------------------------- IMPORTANT NOTICE:
This message (and any attachment hereto) may contain privileged and/or confidential information specific to EasyCall. If you are not the intended addressee indicated in this message, you may not copy or disseminate this message (or any attachment hereto) to anyone. Instead, please destroy this message (and any attachment hereto), and kindly notify the sender by reply email. Any information in this message (and any attachment thereto) that do not relate to the official business of EasyCall shall be understood as neither given nor endorsed by the company.
-----Original Message----- From: Kevin Fonner [SMTP:fonn...@greenfern.com] Sent: Thursday, May 10, 2001 6:11 AM To: Java MySQL List Subject: authentication
I am writing a java program that authenticates itself with a database in mysql. Is it possible to use the actual mysql user table to authenticate against? Is this wise? And if so can I add additional columns for my own purposes?




