Check the user_auths table : User Table « User Permission « SQL / MySQL

1.	Aggregate Functions
2.	Backup Load
3.	Command MySQL
4.	Cursor
5.	Data Type
6.	Database
7.	Date Time
8.	Engine
9.	Event
10.	Flow Control
11.	FullText Search
12.	Function
13.	Geometric
14.	I18N
15.	Insert Delete Update
16.	Join
17.	Key
18.	Math
19.	Procedure Function
20.	Regular Expression
21.	Select Clause
22.	String
23.	Table Index
24.	Transaction
25.	Trigger
26.	User Permission
27.	View
28.	Where Clause
29.	XML

SQL / MySQL » User Permission » User Table

Check the user_auths table

      



SELECT   GRANTEE

FROM     USER_AUTHS

WHERE    PRIVILEGE = 'SELECT'

UNION

SELECT   GRANTEE

FROM     DATABASE_AUTHS

WHERE    DATABASE_NAME = 'TENNIS'

AND      PRIVILEGE = 'SELECT'

UNION

SELECT   GRANTEE

FROM     TABLE_AUTHS

WHERE    TABLE_CREATOR = 'TENNIS'

AND      PRIVILEGE = 'SELECT'

AND      TABLE_NAME = 'PLAYERS'

Related examples in the same category

1.	Query user table
2.	Deal with users who can log in from anywhere
3.	Check the just created user by querying the user table
4.	Verify that the user table contains the proper host and user rows.
5.	How an account would be added to the user table
6.	Query the user table
7.	Check for user authentication for current user

java2s.com | Contact Us | Privacy Policy

All other trademarks are property of their respective owners.