sqlplus /
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: sqlplus /

Hybrid View

  1. #1
    Join Date
    Jan 2000
    Location
    san jose
    Posts
    149
    how to setup so by simply input
    sqlplus /
    it will let me in without provider username and password?

  2. #2
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    You have to setup OS authentication to login with no username and password.
    Reddy,Sam

  3. #3
    Join Date
    Mar 2001
    Location
    Ireland/Dublin
    Posts
    684
    If you use UNIX, you have to create unix user and oracle user with the same name (LARRY). After that, when you connect to unix as LARRY, you may use:
    sqlplus /

    CREATE USER "LARRY" IDENTIFIED EXTERNALLY DEFAULT TABLESPACE "USERS" TEMPORARY TABLESPACE "TEMP" PROFILE DEFAULT ACCOUNT UNLOCK;

  4. #4

    security issue

    Hi there,
    I would avoid external authentification:- As far as I know it may be a security risk. Lets say someone knows that I have a database account ops$BOB. All they need to do then is to set up an account on their NT laptop of BOB and if they can then get onto the network then they can then log into my account on the database. I know when I worked at the hospital, we had to change from using external authentification across the board for this or a similar reason (it was a good while back now)

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