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 |