Results 1 to 3 of 3

Thread: Database users

  1. #1
    Join Date
    Jan 2002
    Posts
    165

    Unanswered: Database users

    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

  2. #2
    Join Date
    Dec 2002
    Location
    Netherlands
    Posts
    118

    profile

    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
    Remi Visser

    Oracle Database Administrator
    (OCP certified 8i)

    Homepage: http://home.remidian.com/

  3. #3
    Join Date
    Jan 2002
    Posts
    165
    Thanks a lot!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •