오라클 사용자 추가 기본 sysdba
|
1 |
sqlplus / as sysdba |
사용자 추가 및 권한 생성
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 |
--- 1. 유저 생성 create user jsh IDENTIFIED BY qwer1234#$ --- 유저 생성시 에러가 발생되는경우 alter session set “_ORACLE_SCRIPT”=true; --- 2. 사용자 권한 부여 grant create session to jsh; grant create table to jsh; grant create sequence to jsh; grant create view to jsh; --- 테이블스페이스 생성(무제한) alter user jsh default TABLESPACE users quota UNLIMITED on users; |
해당 사용자 모드로 oracle 접속 후 students 테이블 생성
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 |
create table students ( student_no varchar(10), surname varchar(20), forename varchar(20)); create table modules ( module_code varchar(8), module_name varchar(20)); create table marks ( student_no varchar(10), module_code varchar(8), mark integer); insert into students values ('20060101','Dickens','Charles'); insert into students values ('20060102','ApGwilym','Dafydd'); insert into students values ('20060103','Zola','Emile'); insert into students values ('20060104','Mann','Thomas'); insert into students values ('20060105','Stevenson','Robert'); insert into modules values ('CM0001', 'Databases'); insert into modules values ('CM0002', 'Programming Languages'); insert into modules values ('CM0003', 'Operating Systems'); insert into modules values ('CM0004', 'Graphics'); insert into marks values ('20060101', 'CM0001', 80); insert into marks values ('20060101', 'CM0002', 65); insert into marks values ('20060101', 'CM0003', 50); insert into marks values ('20060102', 'CM0001', 75); insert into marks values ('20060102', 'CM0003', 45); insert into marks values ('20060102', 'CM0004', 70); insert into marks values ('20060103', 'CM0001', 60); insert into marks values ('20060103', 'CM0002', 75); insert into marks values ('20060103', 'CM0004', 60); insert into marks values ('20060104', 'CM0001', 55); insert into marks values ('20060104', 'CM0002', 40); insert into marks values ('20060104', 'CM0003', 45); insert into marks values ('20060105', 'CM0001', 55); insert into marks values ('20060105', 'CM0002', 50); insert into marks values ('20060105', 'CM0004', 65); commit; |