//계정생성
SQL> CREATE USER scott IDENTIFIED BY tiger;
USER created.
- 접속 및 테이블 관련 권한을 주고
GRANT CONNECT, RESOURCE TO scott;
CONNECT : 데이터베이스에 접속할수 있는 기본권한을 가진롤
RESOURCE : 기본적인 객체(테이블, 인덱스, 뷰, 클러스트 등)을 생성, 변경, 삭제할 수 있는 권한을 가진롤
-세션 권한 주고
grant alter session to scott;
- plustrace 권한주고
grant plustrace to scott;
GRANT succeeded.
완료.
물로.. Scott계정에 기본적으로 제공되던 테이블같은건 하나도 없다
[참고 ]
-이미 존재하는 계정 test에 대해 암호(passwd) 변경 및 활성화 명령 실행
ALTER USER test IDENTIFIED BY passwd UNLOCK;
[출처] [Oracle]Scott계정이 존재 하지 않는다고 나올때|작성자 천재마도사 http://blog.naver.com/sipzirala/220065043509
[출처] [Oracle]Scott계정 생성|작성자 sipzirala
출처 : http://www.zetswing.com/bbs/board.php?bo_table=ORACLE_TIP2&wr_id=28
CREATE TABLE DEPT
(
DEPTNO NUMBER(2) CONSTRAINT pk_dept PRIMARY KEY,
DNAME VARCHAR2(14),
LOC VARCHAR2(13)
);
INSERT INTO DEPT VALUES (10, 'ACCOUNTING', 'NEW YORK');
INSERT INTO DEPT VALUES (20, 'RESEARCH', 'DALLAS');
INSERT INTO DEPT VALUES (30, 'SALES', 'CHICAGO');
INSERT INTO DEPT VALUES (40, 'OPERATIONS', 'BOSTON');
COMMIT;
CREATE TABLE EMP
(
EMPNO NUMBER(4) CONSTRAINT pk_emp PRIMARY KEY,
ENAME VARCHAR2(10),
JOB VARCHAR2(9),
MGR NUMBER(4),
HIREDATE DATE,
SAL NUMBER(7, 2),
COMM NUMBER(7, 2),
DEPTNO NUMBER(2) CONSTRAINT fk_emp_dept REFERENCES dept(deptno)
);
insert into emp (EMPNO, ENAME, JOB, MGR, HIREDATE, SAL, COMM, DEPTNO) values ('7839', 'KING', 'PRESIDENT', '', TO_DATE('11/17/1981', 'MM/DD/YYYY'), '5000', '', '10');
insert into emp (EMPNO, ENAME, JOB, MGR, HIREDATE, SAL, COMM, DEPTNO) values ('7698', 'BLAKE', 'MANAGER', '7839', TO_DATE('05/01/1981', 'MM/DD/YYYY'), '2850', '', '30');
insert into emp (EMPNO, ENAME, JOB, MGR, HIREDATE, SAL, COMM, DEPTNO) values ('7782', 'CLARK', 'MANAGER', '7839', TO_DATE('06/09/1981', 'MM/DD/YYYY'), '2450', '', '10');
insert into emp (EMPNO, ENAME, JOB, MGR, HIREDATE, SAL, COMM, DEPTNO) values ('7566', 'JONES', 'MANAGER', '7839', TO_DATE('04/02/1981', 'MM/DD/YYYY'), '2975', '', '20');
insert into emp (EMPNO, ENAME, JOB, MGR, HIREDATE, SAL, COMM, DEPTNO) values ('7788', 'SCOTT', 'ANALYST', '7566', TO_DATE('12/09/1982', 'MM/DD/YYYY'), '3000', '', '20');
insert into emp (EMPNO, ENAME, JOB, MGR, HIREDATE, SAL, COMM, DEPTNO) values ('7902', 'FORD', 'ANALYST', '7566', TO_DATE('12/03/1981', 'MM/DD/YYYY'), '3000', '', '20');
insert into emp (EMPNO, ENAME, JOB, MGR, HIREDATE, SAL, COMM, DEPTNO) values ('7369', 'SMITH', 'CLERK', '7902', TO_DATE('12/17/1980', 'MM/DD/YYYY'), '800', '', '20');
insert into emp (EMPNO, ENAME, JOB, MGR, HIREDATE, SAL, COMM, DEPTNO) values ('7499', 'ALLEN', 'SALESMAN', '7698', TO_DATE('02/20/1981', 'MM/DD/YYYY'), '1600', '300', '30');
insert into emp (EMPNO, ENAME, JOB, MGR, HIREDATE, SAL, COMM, DEPTNO) values ('7521', 'WARD', 'SALESMAN', '7698', TO_DATE('02/22/1981', 'MM/DD/YYYY'), '1250', '500', '30');
insert into emp (EMPNO, ENAME, JOB, MGR, HIREDATE, SAL, COMM, DEPTNO) values ('7654', 'MARTIN', 'SALESMAN', '7698', TO_DATE('09/28/1981', 'MM/DD/YYYY'), '1250', '1400', '30');
insert into emp (EMPNO, ENAME, JOB, MGR, HIREDATE, SAL, COMM, DEPTNO) values ('7844', 'TURNER', 'SALESMAN', '7698', TO_DATE('09/08/1981', 'MM/DD/YYYY'), '1500', '0', '30');
insert into emp (EMPNO, ENAME, JOB, MGR, HIREDATE, SAL, COMM, DEPTNO) values ('7876', 'ADAMS', 'CLERK', '7788', TO_DATE('01/12/1983', 'MM/DD/YYYY'), '1100', '', '20');
insert into emp (EMPNO, ENAME, JOB, MGR, HIREDATE, SAL, COMM, DEPTNO) values ('7900', 'JAMES', 'CLERK', '7698', TO_DATE('12/03/1981', 'MM/DD/YYYY'), '950', '', '30');
insert into emp (EMPNO, ENAME, JOB, MGR, HIREDATE, SAL, COMM, DEPTNO) values ('7934', 'MILLER', 'CLERK', '7782', TO_DATE('01/23/1982', 'MM/DD/YYYY'), '1300', '', '10');
COMMIT;