Categories:
.NET (357)
C (330)
C++ (183)
CSS (84)
DBA (2)
General (7)
HTML (4)
Java (574)
JavaScript (106)
JSP (66)
Oracle (114)
Perl (46)
Perl (1)
PHP (1)
PL/SQL (1)
RSS (51)
Software QA (13)
SQL Server (1)
Windows (1)
XHTML (173)
Other Resources:
How To Revoke User Privileges
How To Revoke User Privileges? - MySQL FAQs - Managing User Accounts and Access Privileges
✍: 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)
2007-05-08, 5212👍, 0💬
Popular Posts:
What is a measure in OLAP ? Measures are the key performance indicator that you want to evaluate. To...
What is difference between custom JSP tags and JavaBeans? Custom JSP tag is a tag you defined. You d...
1. What is normalization. 2. Difference between procedure and functions. 3. Oracle 9i Vs 10g. 4. how...
.NET INTERVIEW QUESTIONS - What is COM ? Microsoft’s COM is a technology for component software deve...
How do we generate strong names ? or What is use the of SN.EXE ? or How do we apply strong names to ...