RE: How to set permissions?
I have totally different task. I don't want to give users any other privileges but SELECT. But because I use MERGE tables for showing reports to users I must give for these tables UPDATE and DELETE privileges. And here I am talking about several hundreds tables for each user. MySQL doesn't have wild cards for table name field in tables_priv. Otherwise it would be very easy: GRANT ... ON db.ab% for user. The only way I see now is to set privileges for each table for each User manually (I mean script). Do you know any other way? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 14, 2002 10:14 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: How to set permissions? This might not be the best way, but for the people here at my office who aren't familiar with command line interfaces, I've setup MyODBC and MS Access. This let's them add/edit user's account info directly. The only thing you can't do (afaik), is change a user's password. -- Mike Miller -- [EMAIL PROTECTED] -Original Message- From: Yana [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 14, 2002 10:01 AM To: [EMAIL PROTECTED] Subject: RE: How to set permissions? Helo! Is there any other way to set permissions to the list of tables in mysql db (big list!) with similar names (f.e. c%), then running a script on it? Thanks - 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 - 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 - 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
RE: How to set permissions?
Helo! Is there any other way to set permissions to the list of tables in mysql db (big list!) with similar names (f.e. c%), then running a script on it? Thanks - 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
RE: Sub-select look-alike?
Is that what you want? SELECT languages.language, languages.fieldN, .., language_pairs.fieldX FROM language_pairs INNER JOIN Languages ON languages.id=language_pairs.id WHERE /* conditions */ -Original Message- From: Andreas Frøsting [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 13, 2002 10:13 AM To: [EMAIL PROTECTED] Subject: Sub-select look-alike? Hi, I have two tables: languages: id tinyint(3) unsigned not null, language varchar(30) not null language_pairs: from tinyint(3) unsigned not null, to tinyint(3) unsigned not null language_pairs.from and language_pairs.to are linked with languages.id (both tables are simplified in this mail and contains a lot more columns, but they are not relevant) Now I want to do a query giving me the names of the languages (languages.language) instead of language_pairs.from og .to. I can only see a solution requiring the use of sub-selects which MySQL doesn't (yet :) has support for. Anyone smarter than me who can see a solution? I want to avoid use of sub-queries if possible, and my emergency plan is to extract all records from `languages` into an array in PHP and simply use PHP to join .from and .to with the matching language. That's not in any way optimal, that's why I'm asking you guys :) regards, //andreas http://phpwizard.dk (in Danish only) - 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 - 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
How to set permissions?
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
