![]() To access and manage the data in the database, a reliable and efficient database management system is required. Its security is of the utmost importance. ![]() Below is the syntax for that:ĭROP USER database is a crucial part of any website that stores all the data. You can also delete the user account using the DROP command. SHOW GRANTS FOR above command displays all the permissions a user has. Below is the syntax to check the permissions: You can also check the permissions granted to a given user. FROM Revoke all permissions from a user over all tables: Revoke select and insert permissions from a user for a table:.FROM are few examples to revoke permissions: Below is the syntax to revoke permissions: Similarly, the permissions can be revoked from the user using the REVOKE keyword. TO Grant insert, delete, and select permissions to a user to access a table: * TO Grant select permissions to a user over a specified table: ![]() GRANT CREATE, SELECT ON * TO Grant all the permissions to a user to access mentioned database:
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |