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