If you want to see a list of all the permissions you’ve granted to a particular user, run this command: SHOW GRANTS FOR Wrapping up To drop a user, run this command: DROP USER How to see a user’s permissions Here’s how you revoke permissions: REVOKE PERMISSION_TYPE ON database_name.table_name FROM How to drop a user For instance, if you know you’re going to fire an employee, you don’t want them having root access to your database. Sometimes, you’ll find yourself needing to take back permissions you’ve previously granted. For example, to give brand_new_user permission to DELETE and DROP, use this command: DELETE, DROP ON database_name. To grant multiple privileges, simply separate them with a comma. How to grant multiple permissions to the same user in MySQL GRANT OPTION – Lets users grant or remove the privileges of other users. FILE – lets users access files on the server.EXECUTE – lets users execute stored routines.ALTER – lets users modify table structure.DROP - lets users delete entire database tables.DELETE - lets users erase table entries.UPDATE - allows users to modify existing entries in tables.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |