MySQL Forums
Forum List  »  Install & Repo

Block table with Mysql
Posted by: Sarah Pham
Date: March 01, 2010 03:02AM

Hi All,

My server is using MySQL 5.0.45 on CentOS 5.
I was wondering if we can block 'insert/update/delete' one table on a database to only one account can access.

Example: I have 'test' database with 3 tables:
test.test1,
test.test2,
test.test3

Initial, the entire test database was owned to 'user1'.
Then, I created a new user 'user2'.
Now, can I configure to only user2 can access to test.test3, the other users (include user1) cannot insert/update/delete on test.test3?

Please help me!!
Thank you so much

Options: ReplyQuote


Subject
Written By
Posted
Block table with Mysql
March 01, 2010 03:02AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.