Do you have a question? Post it now! No Registration Necessary.  Now with pictures!

Threaded View
I would like to ask , if I can restrict a user from a single table.
I want him to be able to create,alter,delete all the tables but one, which
I want him not to delete it, not to update it not to create it.Just to use

Can I do it?

As long as I have read there is only the way to give credentials for all
the objects of the database.

Re: Privileges

D. Mexis wrote:

Quoted text here. Click to load it

revoke all privileges on db.tablename from user [,user2,...];
grant select on db.tablename to user[,user2,...];

user = 'username'@'localhost'

Now he will only be able to "read" this table.

Michael Austin.

Re: Privileges

Thank you!

Site Timeline