Collections:
Revoking User Privileges in MySQL
How To Revoke User Privileges in MySQL?
✍: FYIcenter.com
If your want remove some granted user privileges, you can use the "REVOKE privilegeName ..." command. You can only revoke privileges in the same way as they were granted. For example, you can not revoke a privilege on a specific database, if that privilege was granted to all databases. The following tutorial exercise shows you how to view user's granted privileges:
>cd \mysql\bin >mysql -u root -pretneciyf mysql> GRANT CREATE ON *.* TO DEV; Query OK, 0 rows affected (0.00 sec) mysql> REVOKE CREATE ON QA.* FROM DEV; ERROR 1141 (42000): There is no such grant defined for user 'DEV' on host '%' mysql> REVOKE CREATE ON *.* FROM DEV; Query OK, 0 rows affected (0.00 sec)
⇒ Giving User Read-only Access in MySQL
⇐ Viewing User Privileges in MySQL
2017-08-21, 3506🔥, 0💬
Popular Posts:
How To Query Tables and Loop through the Returning Rows in MySQL? The best way to query tables and l...
What To Do If the StartDB.bat Failed to Start the XE Instance in Oracle? If StartDB.bat failed to st...
How To Count Rows with the COUNT(*) Function in SQL Server? If you want to count the number of rows,...
How to download and install Microsoft .NET Framework Version 2.0 in SQL Server? .NET Framework Versi...
How To Replace Given Values with NULL using NULLIF() in SQL Server Transact-SQL? Sometime you want t...