达梦数据库 给SysDBA 设置表访问权限

 

GRANT SELECT ON 模式.表名 TO SYSDBA;

BEGIN
    FOR rec IN (SELECT table_name FROM all_tables WHERE owner = '模式') LOOP
        EXECUTE IMMEDIATE 'GRANT SELECT ON 模式.' || rec.table_name || ' TO SYSDBA';
    END LOOP;
END;

 

GRANT SELECT, INSERT, UPDATE, DELETE ON WISDOM_VIDEO_CD_JT.SP_ProjectSectionEx TO SYSDBA;

GRANT EXECUTE ON WISDOM_VIDEO_CD_JT.ConvertAreaCodesToNames TO SYSDBA;