RE: [PHP] Re: Privilege system of Mysql...

2001-03-19 Thread Jeff Armstrong
and future databases. Regards Jeff -Original Message- From: David Bouw [mailto:[EMAIL PROTECTED]] Sent: Monday, March 19, 2001 11:28 AM To: Sven Huster Cc: [EMAIL PROTECTED] Subject: [PHP] Re: Privilege system of Mysql... Hi Sven, Yes, I just started playing with the GRANT syntax.. Only

[PHP] Re: Privilege system of Mysql...

2001-03-19 Thread Sven Huster
David, i think, you can do GRANT SELECT,INSERT ON TO [EMAIL PROTECTED] identified by "password" to allow only SELECTS/INSERTS on the table or just SELECTS with GRANT SELECT ON ... or did i get you wrong? Am 12:27 19.03.2001 schrieb David Bouw: >*This message was transferred with a trial versi

[PHP] Re: Privilege system of Mysql...

2001-03-19 Thread David Bouw
Hi Sven, Yes, I just started playing with the GRANT syntax.. Only problem is that they first define a user with everything on 'N' And then they define a table in the DB with everything on Y... Problem is that you have to do this for all DB's which you want to allow. This means that newly created