达梦数据字典匹配查询

记不得数据字典全名，使用关键字匹配查询数据字典名称，比如权限: priv

doc/dba.pdf中《附录 1 数据字典》对数据字典的每个字段有说明
附录1中，第1个就是SYS.SYSOBJECTS – 对应oracle中的dictionary视图,dba_objects
附录2中，第1个就是V$DYNAMIC_TABLES动态性能视图表
– 比如：查询权限相关的字典

-- dict.sql
define v_name='&1'
select distinct owner,name from (
 select distinct coalesce(USERNAME,'') OWNER,NAME -- ,TYPE$,SUBTYPE$
 from SYS.SYSOBJECTS d,DBA_USERS u where d.SCHID=u.USER_ID(+)
 and SUBTYPE$ in('STAB','VIEW')
 and name like upper('%&v_name%')
union
 select '',name from V$DYNAMIC_TABLES where name like upper('%&v_name%')
) t order by 1,2
;

SQL> `dict priv

OWNER NAME              
----- ------------------
      ALL_COL_PRIVS
      ALL_TAB_PRIVS
      DBA_COL_PRIVS
      DBA_ROLE_PRIVS
      DBA_SYS_PRIVS
      DBA_TAB_PRIVS
      SESSION_PRIVS
      USER_COL_PRIVS
      USER_ROLE_PRIVS
      USER_SYS_PRIVS
      USER_TAB_PRIVS
      V$DB_OBJPRIV_CACHE
      V$DB_SYSPRIV_CACHE

13 rows got

11 rows got


SQL> select * from DBA_SYS_PRIVS where GRANTEE='PUBLIC';

GRANTEE PRIVILEGE                ADMIN_OPTION
------- ------------------------ ------------
PUBLIC  INSERT TABLE             NO
PUBLIC  UPDATE TABLE             NO
PUBLIC  DELETE TABLE             NO
PUBLIC  SELECT TABLE             NO
PUBLIC  REFERENCES TABLE         NO
PUBLIC  GRANT TABLE              NO
PUBLIC  INSERT VIEW              NO
PUBLIC  UPDATE VIEW              NO
PUBLIC  DELETE VIEW              NO
PUBLIC  SELECT VIEW              NO
PUBLIC  GRANT VIEW               NO
PUBLIC  EXECUTE PROCEDURE        NO
PUBLIC  GRANT PROCEDURE          NO
PUBLIC  SELECT SEQUENCE          NO
PUBLIC  GRANT SEQUENCE           NO
PUBLIC  EXECUTE PACKAGE          NO
PUBLIC  GRANT PACKAGE            NO
PUBLIC  SELECT ANY DICTIONARY    NO
PUBLIC  SELECT MATERIALIZED VIEW NO
PUBLIC  GRANT DOMAIN             NO
PUBLIC  USAGE DOMAIN             NO
PUBLIC  DUMP TABLE               NO

22 rows got