BCOM 사용자를 생성합니다. |
-- ------------------------------------------------------------------------------------------------
-- 사용자 접속
system/****@vis1229;
-- ------------------------------------------------------------------------------------------------
show user;
set trimspool on;
set timing on;
set heading on;
set linesize 205;
set pagesize 20;
-- ------------------------------------------------------------------------------------------------
-- bcom 사용자 생성
-- ------------------------------------------------------------------------------------------------
drop user bcom cascade;
create user bcom identified by "****"
default tablespace bdb_data
temporary tablespace temp
profile default
quota unlimited on bdb_data
quota unlimited on bdb_idx;
-- 롤권한
grant connect to bcom;
grant resource to bcom;
-- 시스템 권한
grant create job to bcom with admin option;
grant create materialized view to bcom with admin option;
grant create operator to bcom with admin option;
grant create procedure to bcom with admin option;
grant create sequence to bcom with admin option;
grant create session to bcom with admin option;
grant create synonym to bcom with admin option;
grant create table to bcom with admin option;
grant create trigger to bcom with admin option;
grant create type to bcom with admin option;
grant create view to bcom with admin option;
grant unlimited tablespace to bcom;
-- ------------------------------------------------------------------------------------------------
-- 사용자 조회
-- ------------------------------------------------------------------------------------------------
select *
from dba_users du
where 1=1
and du.account_status = 'OPEN'
and du.default_tablespace = upper('bdb_data')
;
'오라클 > 사용자' 카테고리의 다른 글
[ BHRM] 오라클 사용자를 생성합니다. (0) | 2024.04.07 |
---|---|
[ BSYS] 오라클 사용자를 생성합니다. (0) | 2024.04.04 |