Re: Limiting privileges

On 12/18/2015 9:41 AM, Derek Turner wrote:
> On Thu, 17 Dec 2015 14:09:07 -0500, Jerry Stuckle wrote:
>

>> See http://dev.mysql.com/doc/refman/5.7/en/account-management-sql.html
>> for more details.

Ah, I missed the "temporary table". I shouldn't read so quickly! :)

You can't grant to a table which doesn't exist. But if you create it as a temporary table, it will only exist as long as the creating session is alive, and will only be accessible by that session.

If you want to let another user access it, you must create a real table, then grant access to that user. Once you're done, you can delete the table.

-- 
==================
Remove the "x" from my email address
Jerry Stuckle
jstucklex_at_attglobal.net
==================