*DM manager工具备份用户最小权限设置
使用达梦 manager工具进行备份用户,需要授予以下权限
create user “BAK” identified by “bak@12345”;
grant “RESOURCE" to “BAK”;
grant BACKUP DATABASE to “BAK”;
grant SELECT on “SYS”.“V$DM_INI” to “BAK”;
grant SELECT on “SYS”.“V$BACKUPSET” to “BAK”;
grant SELECT on “SYS”.“V$BACKUPSET_SUBS” to “BAK”;
grant SELECT on “SYS”.“V$BACKUPSET_TABLE” to “BAK”;
grant SELECT on “SYS”.“V$BACKUPSET_SEARCH_DIRS” to “BAK”;
grant SELECT on “SYS”.“V$BACKUPSET_BKP” to “BAK”;
grant SELECT on “SYS”.“V$BACKUPSET_DBF” to “BAK”;
grant SELECT on “SYS”.“V$BACKUPSET_DBINFO” to “BAK”;
grant SELECT on “SYS”.“V$BACKUPSET_ARCH” to “BAK”;
grant SELECT on “SYS”.“V$CIPHERS” to “BAK”;*