사용자 생성

[linux@localhost db]$ sqlplus system
SQL*Plus: Release 8.0.5.0.0 - Production on 화 Oct 5 23:43:19 1999
(c) Copyright 1998 Oracle Corporation.  All rights reserved.
암호 입력: 
Connected to:
Oracle8 Release 8.0.5.0.0 - Production
PL/SQL Release 8.0.5.0.0 - Production


SQL> select * from v$tablespace;

       TS# NAME
---------- ------------------------------
         0 SYSTEM
         1 RBS
         2 
         3 
         4 TOOLS
         5 INDX

6 rows selected.

SQL> create user kang identified by kang
  2  default tablespace users
  3  temporary tablespace temp;
사용자가 생성되었습니다.




SQL> grant connect, resource to kang;
권한이 부여되었습니다.

SQL> select * from dba_roles;
ROLE                           PASSWORD
------------------------------ --------
CONNECT                        NO
RESOURCE                       NO
DBA                            NO
SELECT_CATALOG_ROLE            NO
EXECUTE_CATALOG_ROLE           NO
DELETE_CATALOG_ROLE            NO
EXP_FULL_DATABASE              NO
IMP_FULL_DATABASE              NO
RECOVERY_CATALOG_OWNER         NO
AQ_ADMINISTRATOR_ROLE          NO
AQ_USER_ROLE                   NO
SNMPAGENT                      NO
OEM_MONITOR                    NO
HS_ADMIN_ROLE                  NO

14 rows selected.

SQL> grant exp_full_database, imp_full_database to kang;

Grant succeeded.

끝