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

Thread: connect / as sysdba

  1. 06-23-2005, 09:39 AM #1
    steeve123
    steeve123 is offline Senior Member
    Join Date
    Nov 2000
    Posts
    440

    connect / as sysdba

    Presently it is possible to connect on my database using connect / as sysdba on the server. 9i

    But i want to obligate user to put a password. How to?
    Reply With Quote Reply With Quote
  2. 06-23-2005, 09:46 AM #2
    TimHall
    TimHall is offline Senior Advisor
    Join Date
    Dec 2001
    Location
    UK
    Posts
    1,684
    Hi.

    It's OS authenticaton. That's the way it is.

    The safest thing to do is not give you root and oracle UNIX password to people you don't trust.

    Cheers

    Tim...
    Tim...
    OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
    OCA PL/SQL Developer
    Oracle ACE Director
    My website: oracle-base.com
    My blog: oracle-base.com/blog
    Reply With Quote Reply With Quote
  3. 06-23-2005, 09:54 AM #3
    GARYM
    GARYM is offline Junior Member
    Join Date
    Aug 2000
    Location
    Straham NH
    Posts
    73
    If you are on Windows then remove the OracleDBA group from the person or from every one.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width