Changing passwords
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 9 of 9

Thread: Changing passwords

Hybrid View

  1. #1
    Join Date
    Dec 2001
    Posts
    337
    Hello everyone,

    How do i change the default passwords for the users system and sys?

    Is there a way of stopping someone from logging in as / as sysdba? can i change that to another value?

    Thanks in advance,
    Chucks_k

  2. #2
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    Originally posted by Chucks_k
    Hello everyone,

    How do i change the default passwords for the users system and sys?

    Is there a way of stopping someone from logging in as / as sysdba? can i change that to another value?

    Thanks in advance,
    Chucks_k
    ALTER USER SYS IDENTIFIED BY NEW_PWD;

    If the unix user is in the DBA group, then he can log in using "connect / as sysdba". Is the OS user in the DBA group?
    Oracle Certified Master
    Oracle Certified Professional 6i,8i,9i,10g,11g,12c
    email: ocp_9i@yahoo.com

  3. #3
    Join Date
    Dec 2001
    Posts
    337
    Hi Julian..thanks for that..
    Yes the oracle user is in the dba group..
    So do i change the group for the oracle user? Will that be ok?

  4. #4
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    Originally posted by Chucks_k
    Hi Julian..thanks for that..
    Yes the oracle user is in the dba group..
    So do i change the group for the oracle user? Will that be ok?
    Well, the Oracle user should be generally in the dba group. So, if someone logs in as oracle at unix level he should not be asked for password after connecting to the DB as internal or / as sysdba.
    Oracle Certified Master
    Oracle Certified Professional 6i,8i,9i,10g,11g,12c
    email: ocp_9i@yahoo.com

  5. #5
    Join Date
    Dec 2001
    Posts
    337
    So how do i avoid someone coming in an entering the statement '/as sysdba' to log into the database?

  6. #6
    Join Date
    Dec 2001
    Location
    Brazil
    Posts
    282


    Just don`t give them the sysdba privilege.
    You can also set remote_login_passwordfile=exclusive
    and use a password file (use orapwd for creating a password file) ... at least in 9i.


    F.

  7. #7
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    disable os authetification, in 9i. in 8i there is no way to avoid connect internal

  8. #8
    Join Date
    May 2002
    Posts
    2,645
    Change the user's group to sysoper from sysdba. Do you not want this person to have sysoper privileges as well, or are you only concerned with sysdba?

  9. #9
    Join Date
    Jul 2001
    Location
    Slovenia
    Posts
    422
    Just change the oracle user password as well. At least one (you) should be able to use it if it is necessary.

    Tomaz

Posting Permissions

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


Click Here to Expand Forum to Full Width