Oracle User Creation

Oracle DB 접속을 위한 사용자 계정 생성 방법

다음은 생성과정이며
사용자 입력은 파란색으로 표시

oracle@server /home/oracle]# sqlplus '/as sysdba'

SQL*Plus: Release 9.2.0.1.0 - Production on Wed Jan 24 11:25:03 2007

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.


Connected to:
Oracle9i Enterprise Edition Release 9.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production

SQL> create user USERNAME identified by PASSWD;

User created.

SQL> grant connect, resource to USERNAME;

Grant succeeded.

SQL> quit

Disconnected from Oracle9i Enterprise Edition Release 9.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production
oracle@OMSU /home/oracle]# sqlplus USERNAME/PASSWD

SQL*Plus: Release 9.2.0.1.0 - Production on Wed Jan 24 11:25:44 2007

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.


Connected to:
Oracle9i Enterprise Edition Release 9.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production

SQL>