Hello all:

I have gone through the documentation, and also the archives, and still
can't grasp why things happen with privileges.

Here is what I am trying to understand and accomplish.  For my own benefit
I'm trying ot understand the user and db tables of mysql.

If I setup a user with no privileges, but in the db table they have
privileges, that user can still select, insert, etc even when it is set to
no in the user table.

A couple questions I have:

What are the differences between the user/db table?
Also for the best security what shoudl I set the privileges to for everyone.
There are multiple db's on the server, and only one user per db, and they
only need the basic privilges, i.e. create tables, select, insert, etc.

Your help is greatly appreciated.

Mike Walth
CinoFusion



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to