List the host, DB, table name and column name for a user : SQL Privilege : User Permission SQL / MySQL

Navioo.com

SQL / MySQL » User Permission » SQL Privilege »

List the host, DB, table name and column name for a user



  

/* oost is the usr name */
SELECT host, db, user, table_name, column_name, column_priv 
   FROM columns_priv WHERE user='oost';

Related Scripts with Example Source Code in same category :

Check the privilege
Grant select and update on two column in a table
Grant with user name and password
Grant select and update to all tables
Grant select and update with time limitation
Check out the privilege for a user
Adding Users to Database
Read the user table
Read host, db, user, table name and table privilege from privilege table
Read column privilege

Leave a Comment / Note

Name (required)

email (will not be published) (required)

Website

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 Load

Command MySQL

Cursor

Data Type

Database

Date Time

Flow Control

Function

Insert Delete Update

Insert Delete Update

Join

Key

Math

Procedure Function

Procedure Function

Select Clause

String

Table Index

Transaction

Trigger

User Permission

User Permission

View

Where Clause

hits counter