C:\>SQLPLUS "/ AS SYSDBA"SQL*Plus: Release 9.2.0.1.0 - Production on Mon Oct 6 11:15:52 2008Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. Connected to: Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.1.0 - ProductionSQL> CREATE USER TTT IDENTIFIED BY "TT@TT";User created.SQL> GRANT CONNECT,PUBLIC TO TTT;Grant succeeded.SQL> CONNECT TTT/"TT@TT"@ORCL Connected.
C:\>SQLPLUS "/ AS SYSDBA"SQL*Plus: Release 9.2.0.1.0 - Production on Mon Oct 6 11:15:52 2008Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - ProductionSQL> CREATE USER TTT IDENTIFIED BY "TT@TT";User created.SQL> GRANT CONNECT,PUBLIC TO TTT;Grant succeeded.SQL> CONNECT TTT/"TT@TT"@ORCL
Connected.