Re: Limiting privileges
From: Derek Turner <frderek_at_suremail.je>
Date: 18 Dec 2015 17:25:38 GMT
Message-ID: <dditshFkjh5U2_at_mid.individual.net>
Date: 18 Dec 2015 17:25:38 GMT
Message-ID: <dditshFkjh5U2_at_mid.individual.net>
On Fri, 18 Dec 2015 10:41:15 -0500, Jerry Stuckle wrote:
> 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.