回應 AD

2018年1月26日 星期五

Oracle 建立新的 user & schema


1. Open Sql Plus window

2. 貼上下面內容按 enter

/ as sysdba

3. 貼上下面內容按 enter

CREATE USER userId IDENTIFIED BY 1234;
GRANT RESOURCE TO userId;
GRANT CONNECT TO userId;
GRANT CREATE VIEW TO userId;
GRANT CREATE SESSION TO userId;
GRANT UNLIMITED TABLESPACE TO userId;