mysql 权限管理 针对某个库 某张表 授权 tables_priv表
2024-10-11 22:38:31
精确到表级别
针对db1的t3表 授予select权限
mysql> grant select on db1.t3 to 'mike'@'localhost';
Query OK, 0 rows affected (0.07 sec)
验证
#只在tables_priv表中可以查到mike用户的select权限
mysql> select * from mysql.tables_priv\G;
*************************** 1. row ***************************
Host: localhost
Db: db1
User: mike
Table_name: t3
Grantor: root@localhost
Timestamp: 0000-00-00 00:00:00
Table_priv: Select
Column_priv:
1 row in set (0.00 sec) ERROR:
No query specified
验证
mysql> exit
Bye
[root@mysql ~]# mysql -umike -p123
Warning: Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 8
Server version: 5.6.36 Source distribution Copyright (c) 2000, 2017, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql>
mysql> use db1;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A Database changed
mysql> show tables;
+---------------+
| Tables_in_db1 |
+---------------+
| t3 |
+---------------+
1 row in set (0.00 sec)
只能看到db1库下面的 t3表 看不到t1表,只放行对t3表查询
最新文章
- Android-组件RadioButton使用技巧
- 常用的WEB服务
- android 图片加载库 Glide 的使用介绍
- json(http://www.cnblogs.com/lanxuezaipiao/archive/2013/05/24/3096437.html)
- Radius session
- [MEAN Stack] First API -- 3. Select by ID with Mongoose and Express
- Objective-C: NSFileManager 的使用
- HashPasswordForStoringInConfigFile 已过时
- Director Scene Layer and Sprite
- 基于 canvas 将图片转化成字符画
- Linux Curl常用命令使用【转】
- 一种基于路网图层的GPS轨迹优化方案
- 转-Web Service中三种发送接受协议SOAP、http get、http post
- Java Swing 界面中文乱码问题解决(Idea环境)
- Android JNI 学习(二):JNI 设计机制
- js代码跑马灯效果-----轮播图字效果!
- Crontab 删除N天前日志
- linux 的常用命令---------第四阶段
- lateral view
- 【linux &; &;&;命令】&;后台(并行)命令 &;&;串行命令