funcs_1/r/is_table_privileges.result

66 CREATE TABLE db_datadict.tb1(f1 INT, f2 INT, f3 INT)
72 GRANT SELECT ON db_datadict.tb1 TO 'testuser1'@'localhost';
75 GRANT ALL    ON db_datadict.tb1 TO 'testuser2'@'localhost' WITH GRANT OPTION;
86 'testuser1'@'localhost'	def	db_datadict	tb1	SELECT	NO
91 GRANT SELECT ON `db_datadict`.`tb1` TO `testuser1`@`localhost`
97 'testuser2'@'localhost'	def	db_datadict	tb1	ALTER	YES
98 'testuser2'@'localhost'	def	db_datadict	tb1	CREATE	YES
99 'testuser2'@'localhost'	def	db_datadict	tb1	CREATE VIEW	YES
100 'testuser2'@'localhost'	def	db_datadict	tb1	DELETE	YES
101 'testuser2'@'localhost'	def	db_datadict	tb1	DELETE HISTORY	YES
102 'testuser2'@'localhost'	def	db_datadict	tb1	DROP	YES
103 'testuser2'@'localhost'	def	db_datadict	tb1	INDEX	YES
104 'testuser2'@'localhost'	def	db_datadict	tb1	INSERT	YES
105 'testuser2'@'localhost'	def	db_datadict	tb1	REFERENCES	YES
106 'testuser2'@'localhost'	def	db_datadict	tb1	SELECT	YES
107 'testuser2'@'localhost'	def	db_datadict	tb1	SHOW VIEW	YES
108 'testuser2'@'localhost'	def	db_datadict	tb1	TRIGGER	YES
109 'testuser2'@'localhost'	def	db_datadict	tb1	UPDATE	YES
113 GRANT ALL PRIVILEGES ON `db_datadict`.`tb1` TO `testuser2`@`localhost` WITH GRANT OPTION
132 'testuser1'@'localhost'	def	db_datadict	tb1	SELECT	NO
133 'testuser2'@'localhost'	def	db_datadict	tb1	ALTER	YES
134 'testuser2'@'localhost'	def	db_datadict	tb1	CREATE	YES
135 'testuser2'@'localhost'	def	db_datadict	tb1	CREATE VIEW	YES
136 'testuser2'@'localhost'	def	db_datadict	tb1	DELETE	YES
137 'testuser2'@'localhost'	def	db_datadict	tb1	DELETE HISTORY	YES
138 'testuser2'@'localhost'	def	db_datadict	tb1	DROP	YES
139 'testuser2'@'localhost'	def	db_datadict	tb1	INDEX	YES
140 'testuser2'@'localhost'	def	db_datadict	tb1	INSERT	YES
141 'testuser2'@'localhost'	def	db_datadict	tb1	REFERENCES	YES
142 'testuser2'@'localhost'	def	db_datadict	tb1	SELECT	YES
143 'testuser2'@'localhost'	def	db_datadict	tb1	SHOW VIEW	YES
144 'testuser2'@'localhost'	def	db_datadict	tb1	TRIGGER	YES
145 'testuser2'@'localhost'	def	db_datadict	tb1	UPDATE	YES
151 GRANT SELECT ON `db_datadict`.`tb1` TO `testuser1`@`localhost`
155 GRANT ALL PRIVILEGES ON `db_datadict`.`tb1` TO `testuser2`@`localhost` WITH GRANT OPTION