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

Thread: Connect Internal desupported

  1. #1
    Join Date
    Mar 2001
    What's the difference between "CONNECT INTERNAL" and "CONNECT / AS SYSDBA"? Oracle says CONNECT INTERNAL will not be supported starting 8i Release 8.2 and all CONNECT INTERNAL should be replaced with, eg. CONNECT / AS SYSDBA.

    How is using CONNECT / AS SYSDBA safer than CONNECT INTERNAL?


  2. #2
    Join Date
    Aug 2001
    Waterloo, On
    A user connected " SYS As SYSDBA" has the same capabilities as a user connected as INTERNAL. Connecting as internal is not recommended since the account has complete access to THE 'REAL' Data Dictionary (default value of Init parameter 07_DICTIONARY ACCESSIBILITY is set to True in Oracle 8i).
    Oracle recommends setting the parameter 07_DICTIONARY ACCESSIBILITY to false and connecting as 'CONNECT USER AS SYSDBA' to avoid casual access to 'real' SYS owned Data Dictionary. In Oracle 9i, the default value for this parameter is false.

    Raminder Singh

    Oracle Certified DBA: Oracle 8i, 9i

    Mail me at raminderahluwalia@rediffmail.com.

  3. #3
    sqlplus "/ as sysdba"
    The brain is a wonderful organ; it starts working the moment you get up in the morning and does not stop until you get into the office.

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