GBase 8a数据库集群,支持用户名密码方式登陆,同时提供了登陆用户信息元数据表gbase.user,以便管理员使用。
目录导航
参考
GBase 8a用户安全策略元数据表user_check介绍
从系统元数据表 gbase.user查看。其字段说明如下
Field | Type | Null | Key | Default | |
Host | char(60) | NO | PRI | 主机 | |
User | char(16) | NO | PRI | 用户 | |
Password | char(41) | NO | 密码 | ||
Select_priv | enum('N','Y') | NO | N | Select权限 | |
Insert_priv | enum('N','Y') | NO | N | Insert权限 | |
Update_priv | enum('N','Y') | NO | N | Update权限 | |
Delete_priv | enum('N','Y') | NO | N | Delete权限 | |
Create_priv | enum('N','Y') | NO | N | Create权限 | |
Drop_priv | enum('N','Y') | NO | N | Drop权限 | |
Reload_priv | enum('N','Y') | NO | N | Flush权限 | |
Shutdown_priv | enum('N','Y') | NO | N | ||
Process_priv | enum('N','Y') | NO | N | Showprocesslist权限 | |
File_priv | enum('N','Y') | NO | N | Selectintooutfile权限,加载用户写权限 | |
Grant_priv | enum('N','Y') | NO | N | 管理权限的权限 | |
References_priv | enum('N','Y') | NO | N | ||
Index_priv | enum('N','Y') | NO | N | 创建和删除索引权限 | |
Alter_priv | enum('N','Y') | NO | N | Alter权限 | |
Show_db_priv | enum('N','Y') | NO | N | Showdatabase权限 | |
Super_priv | enum('N','Y') | NO | N | ||
Create_tmp_table_priv | enum('N','Y') | NO | N | 创建临时表权限 | |
Lock_tables_priv | enum('N','Y') | NO | N | 锁表权限 | |
Execute_priv | enum('N','Y') | NO | N | 执行存储过程和函数权限 | |
Repl_slave_priv | enum('N','Y') | NO | N | ||
Repl_client_priv | enum('N','Y') | NO | N | ||
Create_view_priv | enum('N','Y') | NO | N | 创建视图 | |
Show_view_priv | enum('N','Y') | NO | N | Showcreateview | |
Create_routine_priv | enum('N','Y') | NO | N | 创建存储过程和函数 | |
Alter_routine_priv | enum('N','Y') | NO | N | 修改存储过程和函数 | |
Create_user_priv | enum('N','Y') | NO | N | 创建用户 | |
Event_priv | enum('N','Y') | NO | N | ||
Trigger_priv | enum('N','Y') | NO | N | ||
ssl_type | enum('','ANY','X509','SPECIFIED') | NO | |||
ssl_cipher | blob | NO | NULL | ||
x509_issuer | blob | NO | NULL | ||
x509_subject | blob | NO | NULL | ||
max_questions | int(11)unsigned | NO | 0 | ||
max_updates | int(11)unsigned | NO | 0 | ||
max_connections | int(11)unsigned | NO | 0 | ||
max_user_connections | int(11)unsigned | NO | 0 | 同时连接的session数 | |
max_cpus | int(11)unsigned | NO | 0 | ||
max_memories | int(11)unsigned | NO | 0 | ||
max_tmp_space | int(11)unsigned | NO | 0 | ||
resource_group | int(11)unsigned | NO | 0 | ||
task_priority | int(11)unsigned | NO | 2 | ||
user_limit_storage_size | char(15) | NO | |||
user_storage_size | int(11)unsigned | NO | 0 |