PDA

View Full Version : How to GRANT rights to tables/databases?


nosmoke
01-19-2002, 05:44 PM
Control panell allows to add a user to a database. How can I GRANT priveleges to a new database users? On some tables/databases I want some users to have only SELECT, on some only INSERT priveleges

Mr. Popularity
01-20-2002, 05:40 AM
hmmm, the way that's setup on the control panel, its too complicated to do that, unless you download MySQL administrator and know how to connect to the database

nosmoke
01-21-2002, 10:22 AM
Well, Control panel won't help at all as I don't have GRANT permission on my databases.