Re: Limiting privileges

On 12/17/2015 1:21 PM, Derek Turner wrote:
> I have a script which creates and modifies a temporary table. I have a
> 'public_connect' user set up and at the moment that user has a lot of
> privileges. Is there a way to limit those just to the temporary table? If
> helps, it doesn't HAVE to be a /temporary/ table - I could use drop if
> exists etc. if that makes things easier.
>

Yes, you can grant privileges on a single table (or view). Just REVOKE all privileges for that user from the database, then GRANT privileges for the table to the user.

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

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