我有台服务器,经常需要重置密码,所以想写个存储过程。
create or replace procedure p_change_password
is
begin execute immediate 'ALTER PROFILE DEFAULT LIMIT PASSWORD_REUSE_TIME UNLIMITED';
execute immediate 'ALTER PROFILE DEFAULT LIMIT PASSWORD_REUSE_MAX UNLIMITED';
execute immediate 'alter user bmp dentified by 12341qaz';
execute immediate 'alter user rcdd dentified by 12341qaz';
execute immediate 'alter user rcdd2 dentified by 12341qaz'; execute immediate 'ALTER PROFILE DEFAULT LIMIT PASSWORD_REUSE_TIME 60';
execute immediate 'ALTER PROFILE DEFAULT LIMIT PASSWORD_REUSE_MAX 5';end p_change_password;
/但执行的时候报错如下:
SQL> exec p_change_password;
BEGIN p_change_password; END;*
ERROR at line 1:
ORA-00922: missing or invalid option
ORA-06512: at "SYS.P_CHANGE_PASSWORD", line 8
ORA-06512: at line 1
求大神解救。
create or replace procedure p_change_password
is
begin execute immediate 'ALTER PROFILE DEFAULT LIMIT PASSWORD_REUSE_TIME UNLIMITED';
execute immediate 'ALTER PROFILE DEFAULT LIMIT PASSWORD_REUSE_MAX UNLIMITED';
execute immediate 'alter user bmp dentified by 12341qaz';
execute immediate 'alter user rcdd dentified by 12341qaz';
execute immediate 'alter user rcdd2 dentified by 12341qaz'; execute immediate 'ALTER PROFILE DEFAULT LIMIT PASSWORD_REUSE_TIME 60';
execute immediate 'ALTER PROFILE DEFAULT LIMIT PASSWORD_REUSE_MAX 5';end p_change_password;
/但执行的时候报错如下:
SQL> exec p_change_password;
BEGIN p_change_password; END;*
ERROR at line 1:
ORA-00922: missing or invalid option
ORA-06512: at "SYS.P_CHANGE_PASSWORD", line 8
ORA-06512: at line 1
求大神解救。
解决方案 »
- oracle 取和的语句
- OracleDBConsoleorcl无法启动 错误997 重叠i/o操作在进行中
- 各位大侠帮帮忙啊
- 被一个弱弱的问题疯狂郁闷,求各位指点
- oci连接数据库,编译后出现 undefined reference to `OCIInitialize' 是什么意思?哪位高手会?
- 客户端连接oracle 出错 ora-12537 TNS:connection closed
- 在块中调用过程碰到的问题
- 很少有人提到的这个问题还是有经验的你来看看吧。。。
- 在软件开发中能够做到完全使用标准sql吗?
- 如何进行数据库优化
- 触发器如何获取触发操作的用户
- oracle 11g ORA-04030
2. 密码用双引号引起来 或者 不要以数字开头