Privileges

[D. Mexis]

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
it.

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.

[Michael Austin]

D. Mexis wrote:

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
it.

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.

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.

[D. Mexis]

Thank you!