oracle user 생성

1. user 생성

a.  일반 접속만 되는 user

 conn / as sysdba;

undefine UserName;

create user &&UserName identified by "&Password"
/

select username from dba_users where username=upper('&UserName')
/

prompt Show Grant!!!!
select grantee, privilege from dba_sys_privs
        where grantee=upper('&UserName')
/

undefine UserName;

 

b. schema 유저(객체를 소유한 유저)- quota,create table,create index, create procedure,create view, etc

conn / as sysdba;

undefine username;

CREATE USER &&username
        PROFILE DEFAULT
        IDENTIFIED BY "&Password"
        DEFAULT TABLESPACE EXAMPLE
        QUOTA 10 M ON EXAMPLE
        ACCOUNT UNLOCK
/
GRANT create session,
        create table,
        create any index,
        create procedure,
        create view,
        CONNECT TO &username
/

select username from dba_users where username=upper('&username')
/

select grantee, privilege from dba_sys_privs
        where grantee=upper('&username')
/