I would like create database user ann.
Also,I would like "disable" user entering
ALTER USER ANN IDENTIFIED BY...
May i configure,and how:
"user cannot change password" or disable
ALTER USER ANN IDENTIFIED BY...
Thanks,Zvonimir

Hi zkajfez

You can to this by creating a profile and a function:

[SYSTEM@DB1.WORLD] CREATE OR REPLACE FUNCTION f_pwd
2 RETURN BOOLEAN
3 AS
4 BEGIN
5 RAISE_APPLICATION_ERROR(-20000, 'You are not allowed to change your password');
6* END;
/

Function created.

[SYS@DB1.WORLD] $ CREATE PROFILE prf_pwd LIMIT PASSWORD_VERIFY_FUNCTION f_pwd;

Profile created.

[SYS@DB1.WORLD] $ ALTER USER scott PROFILE prf_pwd ;

User altered.

Good Luck

Remi

http://askremi.ora-0000.com

Thanks a lot!