Does you have the rights to use the GRANT and REVOKE commands directly? If not those, do you have rights to INSERT and DELETE from the users table of the mysql database? If you do, you could possibly bypass their "one user per databse" rule and create your own.
Otherwise I think you are stuck as each query's privileges can only be evaluated in the context of a single user. (No query can assume two identities at the same time.) Just a suggestion, Shawn Green Database Administrator Unimin Corporation - Spruce Pine [EMAIL PROTECTED] wrote on 07/16/2004 09:01:21 AM: > Hi. > > Is it possible to make a select from different tables that reside in > different databases that have different usernames? The fact is that > I'm using Helm Web Hosting Control tool for creating databases and > users, and it let's me create only one user per database, so I can't > assign a user to multiple databases (and my select problem would go) > > Thanks in advance!
