Oracle 11.2.0.3.6
Solaris 10
I have a primary database and an Active Data Guard physical standby database. My read-only database users need to be able to change their password from the read-only standby. I tried creating a stored procedure with an ALTER USER statement in it and then having my user call the stored proc from the read-only standby by: EXEC MIMI.CHGPWD@PRIM();
This results in:
ERROR at line 1:
ORA-16000: database open for read-only access
ORA-06512: at "MIMI.CHGPWD", line 27
ORA-06512: at line 1
How can I allow a user who can only access the read-only database to change their password from the read-only standby?
Here my stored procedure:
CREATE OR REPLACE PROCEDURE MIMI.CHGPWD IS
--CREATE OR REPLACE PROCEDURE CHGPWD IS
sql_stmt VARCHAR2(200);
BEGIN
sql_stmt := 'ALTER USER MIMITEST IDENTIFIED BY 111111';
EXECUTE IMMEDIATE sql_stmt;
END CHGPWD;
/