Hello, I am trying to set permissions for a new user. The only thing this user is allowed to do is to monitor traffic reports. Normally, just SELECT would be enough. But, to show him this report, program does MERGE of several tables. In this database I have 10 static tables, all other tables are Dynamically creating every day (about 500 tables for now). I can not give to this user privileges other then SELECT, But in order to create MERGE table for his report I must give him UPDATE and DELETE also. CREATE an DROP for the future MERGED table Is not enough. Does anybody know how to resolve this problem? I would be happy to avoid merging the tables, but I don't know Any other method how to make query from about 20-60 identical tables Joined to static tables.
Thank You in advance, Yana --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
