Read host, db, user, table name and table privilege from privilege table : SQL Privilege : User Permission SQL / MySQL

SQL / MySQL » User Permission » SQL Privilege »

 

Read host, db, user, table name and table privilege from privilege table



  

SELECT host, db, user, table_name, table_priv, column_priv 
   FROM tables_priv WHERE user='myuserName';

           
       



Leave a Comment / Note


Vérification Refresh
  
Enter code
Verification is used to prevent unwanted posts (spam). .

Follow Navioo On Twitter

SQL / MySQL

Navioo User Permission
» SQL Privilege
Backup LoadBackup Load
Command MySQLCommand MySQL
CursorCursor
Data TypeData Type
DatabaseDatabase
Date TimeDate Time
Flow ControlFlow Control
FunctionFunction
Insert Delete UpdateInsert Delete Update
JoinJoin
KeyKey
MathMath
Procedure FunctionProcedure Function
Select ClauseSelect Clause
StringString
Table IndexTable Index
TransactionTransaction
TriggerTrigger
User PermissionUser Permission
ViewView
Where ClauseWhere Clause