DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Connect as SYS user- possible without PWD??

  1. #1
    Join Date
    May 2002
    Posts
    193

    Connect as SYS user- possible without PWD??- OS User not in DBA group

    Connect as SYS user- possible without PWD??
    Dear All,



    Right now I have a different kind of a problem (opposite to the one that I faced before). In one of the databases here, Iam able to connect as sys user with SYSDBA privs even though that user is not even in the group DBA ( I checked the group the user is assigned to with the ID command). But for anyother Oracle user, login is possible with the password.

    SUN OS 5.8

    Oracle 9.0.1

    Looking forward to hear further from you, a solution to this problem.

    Regards,

    K.Diwakar
    Last edited by diwakar; 03-25-2003 at 02:53 AM.

  2. #2
    Join Date
    Sep 2000
    Location
    Chennai, India
    Posts
    865
    Post the exact sequence of steps followed verbatim for the 2 users quoted, right from the OS login.

    BTW, post also the result of 'groups' for both the users.

    HTH.
    Last edited by ggnanaraj; 03-25-2003 at 03:11 AM.

  3. #3
    Join Date
    May 2002
    Posts
    193
    Dear Gnanaraj,

    Pls find the steps below. Iam new to SUN/UNIX. Kindly point out how I should proceed..

    Regards,

    K.Diwakar



    $ id
    uid=1003(oasisadm) gid=102(oasis)
    $ export ORACLE_SID=oasis
    $ echo $ORACLE_SID
    oasis
    $ sqlplus

    SQL*Plus: Release 9.0.1.0.0 - Production on Tue Mar 25 14:15:54 2003

    (c) Copyright 2001 Oracle Corporation. All rights reserved.

    Enter user-name: sys as sysdba
    Enter password: (no password entered)

    Connected to:
    Oracle9i Enterprise Edition Release 9.0.1.0.0 - Production
    With the Partitioning option
    JServer Release 9.0.1.0.0 - Production

    SQL> select instance_name from v$instance;

    INSTANCE_NAME
    ----------------
    oasis

    SQL> connect
    Enter user-name: oasis
    Enter password: (Password entered)
    Connected.
    SQL> connect oasis
    Enter password: (Password not entered)
    ERROR:
    ORA-01017: invalid username/password; logon denied


    Warning: You are no longer connected to ORACLE.
    SQL>

  4. #4
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    cat /etc/group |grep dba

    cat /etc/passwd | grep oasisadm

    paste here

  5. #5
    Join Date
    May 2002
    Posts
    193
    Hey Pandi,

    Here is the output:

    $ cat /etc/group |grep dba
    dba::400asisadm,op,crdadm
    $ cat /etc/passwd | grep oasisadm
    oasisadm:x:1003:102:Oasis Admin User:/oasis/ist73:/bin/ksh




    but as you say, the problem is solved. We can see the oasisadm user on DBA group also. The command:


    $ whoami
    oasisadm


    $ id -a
    uid=1003(oasisadm) gid=102(oasis) groups=102(oasis),1(other),2(bin),3(sys),4(adm),5(uucp),6(mail),7(tty),400(dba)
    $



    We can see that OASISADM belongs to group OASIS as well as DBA. Sorry for Iam new to UNIX and just getting on slowly. and as I could not look for DBA in the command:

    $ id
    uid=1003(oasisadm) gid=102(oasis)

    I proceeded with the post. Thank u Gnanraj and Pando. Looking forward for continued support from you all.

    Regards,

    K.Diwakar

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