适用于ORACLE11G//获取用户所属的profileSELECT username,PROFILE FROM dba_users;//查看profile的密码有效期 默认是180天SELECT * FROM dba_profiles s WHERE s.profile=‘DEFAULT‘ AND resource_name=‘PASSWORD_LIFE_TIME‘;//修改密码有效期ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED; //如果数据库已经提示密码即将过期，则你进行以上设置后，还需要再修改一次密码使用sysdba登录 修改密码即可。 备忘：如果...
查看Oracle密码尝试限制次数SQL> desc dba_profilesName Null? Type----------------------------------------- -------- ----------------------------PROFILE NOT NULL VARCHAR2(128)RESOURCE_NAME NOT NULL VARCHAR2(32)RESOURCE_TYPE VARCHAR2(8)LIMIT ...
一.修改密码1)修改密码 sql>alter user user01 identified by password; 2)修改密码并unlock sql>alter user user01 account unlock identified by password;3)解锁操作sql>alter user user01 account unlock 二.设置密码有效期1、查看用户的proifle是哪个，一般是default： sql>SELECT username,PROFILE FROM dba_users; 2、查看指定概要文件（如default）的密码有效期设置： sql>SELECT * FROM dba_profiles s WHERE s....
LSNRCTL change_password Old password: New password: Reenter new password: Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=ecp-uc-db1)(PORT=1521))) Password changed for LISTENER The command completed successfully LSNRCTL set passwor LSNRCTL> change_password Old password: New password: Reenter new password: Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=ecp-uc-db1)(PORT=1521))) Pass...