分类: Oracle
2008-08-31 15:08:12
The following statement creates the profile app_user
:
CREATE PROFILE app_user LIMIT SESSIONS_PER_USER UNLIMITED CPU_PER_SESSION UNLIMITED CPU_PER_CALL 3000 CONNECT_TIME 45 LOGICAL_READS_PER_SESSION DEFAULT LOGICAL_READS_PER_CALL 1000 PRIVATE_SGA 15K COMPOSITE_LIMIT 5000000; Setting Profile Password Limits: ExampleThe following statement creates the
app_user2
profile with password limits values set:CREATE PROFILE app_user2 LIMIT FAILED_LOGIN_ATTEMPTS 5 PASSWORD_LIFE_TIME 60 PASSWORD_REUSE_TIME 60 PASSWORD_REUSE_MAX 5 PASSWORD_VERIFY_FUNCTION verify_function PASSWORD_LOCK_TIME 1/24 PASSWORD_GRACE_TIME 10; 2)将user profile指定给用户2.1新建用户的果候指定user profile:create user testxxxxxprofile xxx(profile_name);2.2为已经存在的用户指定user profile:alter user testprofile new_profile_name