Click to See Complete Forum and Search --> : Deny access to DB?


Anon
07-04-2001, 02:22 PM
I want to share my mySQL with other users but deny accesses for my own databases. I thought that I could use this line to deny access to the database test but it didn't work.

INSERT INTO db
(Host,Db,User,Select_priv,Insert_priv,Update_priv,Delete_priv,
Create_priv,Drop_priv)
VALUES
('localhost','test','testuser','N','N','N','N','N','N');

Any suggestions?