Under Windows:
1. Establish a group: ORA_DBA2. Create User: Test, join TEST to group Ora_DBA3.SQLNET.ORA parameter file, you must set SQLNET.AUTHENTICATION_SERVICES = (NTS)
Use connect / as sysdba when logging in
Under UNIX / Linux:
SQL> Show parameters os_authent_prefix name type value ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ ---------------------------- OS_AUTHENT_PREFIX STRING OPS $ SQL> CREATE USER "OPS $ Oracle" Profile "default" Identified External DEFAULT TABLESPACE "USERS" TEMPORARY TABLESPACE "TEMP"; User created SQL> grant connect to ops $ oracle;... Grant succeeded SQL> conn / Connected SQL> SQL> show user USER is "OPS $ ORACLE" SQL> SQL> exit Disconnected from Oracle10i Enterprise Edition Release 10.1.0.0.0 - Beta with the parting, OLAP AND ORACLE DATA MINING OPTIONS [Oracle @ Linux Oracle] $ SQLPLUS / SQL * Plus: Release 10.1.0.0.0 - Beta on Tue Aug 19 16:04: 46 2003 Copyright (c) 1982, 2003, Oracle Corporation All rights reserved Connected to:.. Oracle10i Enterprise Edition Release 10.1.0.0.0 - Beta With the Partitioning, OLAP and Oracle Data Mining options SQL> show user USER is "OPS $ Oracle "SQL" When you create a user, the name is OS_AUTHENT_PREFIX OS Name This is usually usually used when the OS Name logs in the database, usually userid = user / pass now UserId = /
