[Tools]  Datenbank: `information_schema`  Tabelle: `USER_PRIVILEGES`

         ---               

SELECT * FROM `USER_PRIVILEGES`

Die Ausführung von SQL-Befehlen kann Daten manipulieren! Der Autor übernimmt keine Haftung bei Datenverlusten.

Daten-Ansicht

Datensatz einfügen    Tabellenstruktur bearbeiten

Tabelle `information_schema`.`USER_PRIVILEGES`
Datensätze 1 - 30 von insgesamt 81    <<    <    >    >>

Ansicht: kompakt   Die Abfrage enthält 4 Spalten
	#	GRANTEE	TABLE_CATALOG	PRIVILEGE_TYPE	IS_GRANTABLE
	1.	'root'@'localhost'	def	SELECT	YES
	2.	'root'@'localhost'	def	INSERT	YES
	3.	'root'@'localhost'	def	UPDATE	YES
	4.	'root'@'localhost'	def	DELETE	YES
	5.	'root'@'localhost'	def	CREATE	YES
	6.	'root'@'localhost'	def	DROP	YES
	7.	'root'@'localhost'	def	RELOAD	YES
	8.	'root'@'localhost'	def	SHUTDOWN	YES
	9.	'root'@'localhost'	def	PROCESS	YES
	10.	'root'@'localhost'	def	FILE	YES
	11.	'root'@'localhost'	def	REFERENCES	YES
	12.	'root'@'localhost'	def	INDEX	YES
	13.	'root'@'localhost'	def	ALTER	YES
	14.	'root'@'localhost'	def	SHOW DATABASES	YES
	15.	'root'@'localhost'	def	SUPER	YES
	16.	'root'@'localhost'	def	CREATE TEMPORARY TABLES	YES
	17.	'root'@'localhost'	def	LOCK TABLES	YES
	18.	'root'@'localhost'	def	EXECUTE	YES
	19.	'root'@'localhost'	def	REPLICATION SLAVE	YES
	20.	'root'@'localhost'	def	REPLICATION CLIENT	YES
	21.	'root'@'localhost'	def	CREATE VIEW	YES
	22.	'root'@'localhost'	def	SHOW VIEW	YES
	23.	'root'@'localhost'	def	CREATE ROUTINE	YES
	24.	'root'@'localhost'	def	ALTER ROUTINE	YES
	25.	'root'@'localhost'	def	CREATE USER	YES
	26.	'root'@'localhost'	def	EVENT	YES
	27.	'root'@'localhost'	def	TRIGGER	YES
	28.	'root'@'localhost'	def	CREATE TABLESPACE	YES
	29.	'root'@'localhost'	def	DELETE HISTORY	YES
	30.	'burkhard'@'localhost'	def	SELECT	YES