oracle 11g增加业务profile
由于oracle 11g默认的profile里面有不少限制，比如180天需修改密码等，针对生产业务数据库用户需修改为一个不受限制的profile权限：
CREATE PROFILE NEW_PROFILE LIMIT
SESSIONS_PER_USER UNLIMITED
CPU_PER_SESSION UNLIMITED
CPU_PER_CALL UNLIMITED
CONNECT_TIME UNLIMITED
IDLE_TIME UNLIMITED
LOGICAL_READS_PER_SESSION UNLIMITED
LOGICAL_READS_PER_CALL UNLIMITED
COMPOSITE_LIMIT UNLIMITED
PRIVATE_SGA UNLIMITED
FAILED_LOGIN_ATTEMPTS UNLIMITED
PASSWORD_LIFE_TIME UNLIMITED
PASSWORD_REUSE_TIME UNLIMITED
PASSWORD_REUSE_MAX UNLIMITED
PASSWORD_LOCK_TIME UNLIMITED
PASSWORD_GRACE_TIME UNLIMITED
PASSWORD_VERIFY_FUNCTION NULL;
alter user db_SC profile NEW_PROFILE;
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/29468144/viewspace-1078399/ ，如需转载，请注明出处，否则将追究法律责任。
