Re: access controll in MySQL

2004-11-19 Thread Steve Suehring
Hmm. Will the users need to connect to the MySQL server itself or is the user administration going to just be using MySQL as a backend database? If you're just using MySQL as a backend repository for users and the users won't be connecting directly to the MySQL database then you probably sho

Re: access controll in MySQL

2004-11-19 Thread Chris Wagner
No, that would be fine, as long as u had an index for the commonly accessed columns. You would need millions of rows to see a performance hit even on a slow system. -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]

access controll in MySQL

2004-11-19 Thread Antonin Karasek
Hi, I plan to create a user administration based on MySQL. And I want to make it really secure :o)) As I know, MySQL privilege system is based on "mysql" database, which is copied into memory at startup. My question is: Should I expect any preformance loss, if some tables (columns_priv, user)