MySQL Forums
Forum List  »  Merge Storage Engine

privileges problem
Posted by: Marco Milon
Date: February 25, 2008 03:34AM


i have a problem with merge tables and privileges.

i want to setup something like this:
i need two users admin and user_2, two tables news_1 and news_2
plus one merge table 'news' with news_1 and news_2.

admin has select, create, update and delete privileges on news_1 and news_2
user_2 has select privileges on news_1 and select, create, update and delete on news_2

my problem is that no matter how i setup privileges for user_2, he can delete news from table news_1 if using the merge table 'news'.

the point is that i want user_2 to have 'read-only' access to table news_1 even if he uses the merge table 'news'.

i hope you understand the problem.

thank you very much.

Options: ReplyQuote

Written By
privileges problem
February 25, 2008 03:34AM
June 24, 2008 02:34PM
June 25, 2008 02:03AM

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.