取消权限

最新推荐文章于 2024-06-14 08:00:00 发布

xyh592

最新推荐文章于 2024-06-14 08:00:00 发布

阅读量283

点赞数

分类专栏： sql SQL

本文链接：https://blog.youkuaiyun.com/xyh592/article/details/85166602

版权

sql 同时被 2 个专栏收录

12 篇文章

订阅专栏

SQL

8 篇文章

订阅专栏

REVOKE INSERT,
 UPDATE,
 DELETE,
 CREATE,
 EXECUTE,
 TRIGGER ON *.*
FROM
	'admin'@'%';


REVOKE SELECT, SHOW VIEW ON `information_schema`.* FROM 'asset'@'%';

REVOKE SELECT
	,
	INSERT,
	UPDATE,
	DELETE,
	CREATE,
	DROP,
	REFERENCES,
	INDEX,
	ALTER,
	CREATE TEMPORARY TABLES,
	LOCK TABLES,
	CREATE VIEW,
	SHOW VIEW,
	CREATE ROUTINE,
	ALTER ROUTINE,
	EXECUTE,
	EVENT,
	TRIGGER ON `admin`.*
FROM
	'admin'@'%';

GRANT SELECT
	ON `admin`.* TO 'admin'@'%';