Automatic Login

When connecting to an Oracle database on the same Windows computer, you can set up SQL*Plus to do an automatic login by following these steps:

1. Create an account in the database <PREFIX>USERX for every Windows user (USERX) who needs access to the database. <PREFIX> is the parameter OS_AUTHENT_PREFIX in the inititialization parameter file for the database (the default is OPS$). See the Oracle8i Reference and the Oracle Advanced Security Administrator's Guide for more information about the OS_AUTHENT_PREFIX initialization parameter.

2. After logging on to Windows as USERX, you can log in to SQL*Plus using / (slash) instead of username/password.

See "Shortcuts to Starting SQL*Plus" in Chapter 2 of SQL*Plus User's Guide and Reference which refers you to this guide for information about automatically logging on to SQL*Plus when you log on to your operating system.