数据库安全服务 DBSS-添加数据资产:使用约束

时间：2024-09-04 14:24:05

使用约束

表1 数据库加密支持纳管的数据源及版本
数据库	版本号
MySQL	5.5 、5.6、5.7、8.0、8.0.13+
Oracle	11.1、11.2、12c、19c
SQLServer	2012、2016
PostgreSQL	9.4、 11.5
DM	6、7.6、8.1
Kingbase	V8 R3、V8 R6
MariaDB	10.2
GaussDB	A
TDSQL	5.7
TBASE	V2.15.17.3
RDS_MYSQL	5.6、5.7、8.0
RDS_PostgreSQL	11

表2 数据库加密的数据库账号权限
数据库	需要select权限的系统表名	数据库账号权限
MySQL	mysql.user performance_schema.*	select insert create update delete drop alter index
RDS_MYSQL	mysql.user performance_schema.*	select insert create update delete drop alter index
TDSQL	mysql.user performance_schema.*	select insert create update delete drop alter index
MariaDB	mysql.user performance_schema.*	select insert create update delete drop alter index
DM	SYS.ALL_SUBPART_KEY_COLUMNS SYS.ALL_USERS SYS.ALL_CONS_COLUMNS SYS.ALL_CONSTRAINTS SYS.ALL_TABLES SYS.ALL_TABLE_COLUMNS SYS.ALL_COL_COMMENTS SYS.ALL_PART_KEY_COLUMNS SYS.ALL_IND_COLUMNS SYS.ALL_INDEXS V$VERSION V$LOCK SYS.DBMS_LOB SYS.DBMS_METADATA	用户角色必须是dba
postgreSQL	pg_catalog.pg_class pg_catalog.pg_index pg_catalog.pg_user pg_catalog.pg_indexes information_schema.columns information_schema.sequences information_schema.tables pg_catalog.pg_sequence	用户必须是表的owner或者是dba
RDS_PostgreSQL	pg_catalog.pg_class pg_catalog.pg_index pg_catalog.pg_user pg_catalog.pg_indexes information_schema.columns information_schema.sequences information_schema.tables pg_catalog.pg_sequence	用户必须是表的owner或者是dba
TBASE	pg_catalog.pg_class pg_catalog.pg_index pg_catalog.pg_user pg_catalog.pg_indexes information_schema.columns information_schema.sequences information_schema.tables pg_catalog.pg_sequence	用户必须是表的owner或者是dba
GAUSSDB	pg_catalog.pg_class pg_catalog.pg_index pg_catalog.pg_user pg_catalog.pg_indexes information_schema.columns information_schema.sequences information_schema.tables pg_catalog.pg_sequence	用户必须是表的owner或者是dba
KINGBASE 8.6（pg模式）	pg_catalog.pg_class pg_catalog.pg_index pg_catalog.pg_user pg_catalog.pg_indexes information_schema.columns information_schema.sequences information_schema.tables pg_catalog.pg_sequence pg_catalog.pg_matviews	用户必须是表的owner或者是dba
KINGBASE 8.3	sys_catalog.sys_class sys_catalog.sys_index sys_catalog.sys_user sys_catalog.sys_indexes information_schema.columns information_schema.sequences information_schema.tables sys_catalog.sys_sequence sys_catalog.sys_matviews	用户必须是表的owner或者是dba
Oracle	SYS.ALL_SUBPART_KEY_COLUMNS SYS.DUAL SYS.ALL_USERS SYS.ALL_CONS_COLUMNS SYS.ALL_CONSTRAINTS SYS.ALL_TABLES SYS.ALL_TABLE_COLUMNS SYS.ALL_COL_COMMENTS SYS.ALL_PART_KEY_COLUMNS SYS.ALL_IND_COLUMNS SYS.ALL_INDEXS SYS.V_$INSTANCE SYS.DBMS_LOB SYS.DBMS_METADATA DBA_TABLES DBA_TAB_COLS	用户角色必须是dba
SQLserver	sys.tables sys.indexes sys.index_columns sys.default_constraints sys.systypes sys.extended_properties sys.foreign_key_columns sys.check_constraints sys.foreign_keys sys.columns sys.objects sys.all_columns sys.types sys.syslogins sys.all_objects sys.schemas sys.key_constraints sys.computed_columns sys.triggers sys.partition_schemes sys.dm_sql_referencing_entities	schemaSelect schemaInsert schmeaUpdate schemaAlter createTable VIEW SERVER STATE 加密表的select 加密表的insert 加密表的alter