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:
Where Are User Privileges Stored on the Server
Where Are User Privileges Stored on the Server? - MySQL FAQs - Managing User Accounts and Access Privileges
✍: FYIcenter.com
MySQL server has a system database, which hosts a number of system tables to system related information like user privileges. Depending on the scope levels, granted user privileges are stored in different tables:
The following tutorial exercise shows you an example of granted privileges at the table level:
>cd \mysql\bin >mysql -u root -pretneciyf mysql> SELECT db, user, create_priv, select_priv -> FROM mysql.db; +---------+-------+-------------+-------------+ | db | user | create_priv | select_priv | +---------+-------+-------------+-------------+ | test | | Y | Y | | test\_% | | Y | Y | | fyi | guest | N | Y | | faq | qa | Y | N | +---------+-------+-------------+-------------+ 4 rows in set (0.00 sec)
2007-05-08, 5222👍, 0💬
Popular Posts:
How do we generate strong names ? or What is use the of SN.EXE ? or How do we apply strong names to ...
How do we assign page specific attributes ? Page attributes are specified using the @Page directive.
Once I have developed the COM wrapper do I have to still register the COM in registry? Yes.
What is the concept of XPOINTER? XPOINTER is used to locate data within XML document. XPOINTER can p...
How To Select an Oracle System ID (SID)? - Oracle DBA FAQ - Creating New Database Instance Manually ...