编辑时间 20200418 #新增系统表 SYS_PROFILES #新增profile语法支持,详见语法定义文件 create profile p1 limit SESSION_PER_USER 10 CPU_PER_SESSION 10 CPU_PER_CALL 10 MAX_CONNECT_TIME 10 MAX_IDLE_TIME 10 READS_PER_SESSION 10 READS_PER_CALL 10 TOTAL_RESOURCE_LIMIT 10 PRIVATE_SGA 10 MAX_STORE_NUM 10 CONNECT_NODES 10 STORE_NODES 10 TEMPSPACE_QUOTA 10 CURSOR_QUOTA 10 FAILED_LOGIN_ATTEMPTS 10 PASSWORD_LIFE_PERIOD 10 PASSWORD_LOCK_TIME 10; create profile p1 limit SESSION_PER_USER default CPU_PER_SESSION default CPU_PER_CALL default MAX_CONNECT_TIME default MAX_IDLE_TIME default READS_PER_SESSION default READS_PER_CALL default TOTAL_RESOURCE_LIMIT default PRIVATE_SGA default MAX_STORE_NUM default CONNECT_NODES default STORE_NODES default TEMPSPACE_QUOTA default CURSOR_QUOTA default FAILED_LOGIN_ATTEMPTS default PASSWORD_LIFE_PERIOD default PASSWORD_LOCK_TIME default; create profile p1 limit SESSION_PER_USER unlimited CPU_PER_SESSION unlimited CPU_PER_CALL unlimited MAX_CONNECT_TIME unlimited MAX_IDLE_TIME unlimited READS_PER_SESSION unlimited READS_PER_CALL unlimited TOTAL_RESOURCE_LIMIT unlimited PRIVATE_SGA unlimited MAX_STORE_NUM unlimited CONNECT_NODES unlimited STORE_NODES unlimited TEMPSPACE_QUOTA unlimited CURSOR_QUOTA unlimited FAILED_LOGIN_ATTEMPTS unlimited PASSWORD_LIFE_PERIOD unlimited PASSWORD_LOCK_TIME unlimited; #待实现功能 修改删除语法实现 profile和用户关联实现 本部分关键字用于标识符处理