Oracle 建立使用者指令

GorgoasTW
1 min readOct 31, 2017

--

-- USER SQLCREATE USER TEST IDENTIFIED BY TESTDEFAULT TABLESPACE SYSTEMTEMPORARY TABLESPACE TEMP;-- QUOTASALTER USER TEST QUOTA UNLIMITED ON SYSTEM;-- ROLESGRANT "CONNECT" TO TEST ;GRANT "RESOURCE" TO TEST ;-- SYSTEM PRIVILEGESGRANT CREATE SESSION TO TEST;-- DELETE USER & TABLEdrop user TEST cascade

--

--

GorgoasTW
GorgoasTW

Written by GorgoasTW

iOS Developer/.NET Developer/Father

No responses yet