logo

한국어

[Fortify]SSC Database 셋팅 (Oracle)

관리자 2018.03.20 14:58 조회 수 : 13

명령행 프롬프트에서 아래의 명령으로 sqlplus로 진입한다.
sqlplus "system/manager as sysdba"
 
-- DB 생성
CREATE TABLESPACE ts_fortify_ssc_18_20 DATAFILE 'D:\oracle\virtual\oradata\orcl\ts_fortify_ssc_18_20.dbf' SIZE 2M AUTOEXTEND ON EXTENT MANAGEMENT LOCAL AUTOALLOCATE;
CREATE USER u_fortify_ssc_18_20 IDENTIFIED BY "mypasswd";
ALTER USER u_fortify_ssc_18_20 DEFAULT TABLESPACE ts_fortify_ssc_18_20;
ALTER USER u_fortify_ssc_18_20 TEMPORARY TABLESPACE TEMP;
GRANT CONNECT, DBA, RESOURCE TO u_fortify_ssc_18_20;
 
-- 사용자 비밀번호 변경
ALTER USER u_fortify_ssc_18_20 IDENTIFIED BY "mypasswd";
 
-- 샥제
-- Oracle 12c의 이전버전 호환을 위한 설정
ALTER SESSION SET "_ORACLE_SCRIPT"=TRUE;
DROP USER u_fortify_ssc_18_20 CASCADE;
DROP TABLESPACE ts_fortify_ssc_18_20 INCLUDING CONTENTS AND DATAFILES CASCADE CONSTRAINTS;
 
-- JDBC URL
-- jdbc:oracle:thin:@10.10.10.105:1521:orcl