[ORACLE] user 생성 및 권한 부여.

ORACLE user 생성 및 권한 부여.

SQL> CREATE USER rocksea IDENTIFIED BY tiger;

User created.

SQL> select username, account_status, to_char(lock_date,'YYYYMMDDHH24MI') LOCK_DATE FROM DBA_USERS ;

USERNAME                       ACCOUNT_STATUS                   LOCK_DATE

------------------------------ -------------------------------- ------------

MGMT_VIEW                      OPEN

SYS                            OPEN

SYSTEM                         OPEN

DBSNMP                         OPEN

SYSMAN                         OPEN

ROCKSEA                         OPEN

SQL> grant connect, dba, resource to rocksea;

Grant succeeded.

.by rocksea