Menu
I have a current mysql user who has SELECT privileges for all the table in database example. How can give that user privileges to add new tables, and alter/add records to the table it created?
573
You can use the SQL GRANT statement to grant SQL SELECT, UPDATE, INSERT, DELETE, and other privileges on tables or views. The WITH GRANT OPTION clause indicates that JONES can grant to other users any of the SQL privileges you granted for the ORDER_BACKLOG table.
Use the grant keyword combined with the table privileges you seek to give the user.
GRANT ALTER, CREATE ON example TO 'someuser'@'somehost';
MySQL Grant
MySQL Table Privileges
75
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
