oracle建立使用者

tianyu156發表於2017-06-02
堅持最小許可權原則,不夠可以再給,可以參照hr方案的許可權設定。
create user dev
  identified by admin
  default tablespace USERS
  temporary tablespace TEMP;

GRANT CREATE SESSION TO dev;
GRANT ALTER SESSION TO dev;
GRANT UNLIMITED TABLESPACE TO dev;
GRANT CREATE TABLE TO dev;
GRANT CREATE CLUSTER TO dev;
GRANT CREATE SYNONYM TO dev;
GRANT CREATE VIEW TO dev;
GRANT CREATE SEQUENCE TO dev;
GRANT CREATE DATABASE LINK TO dev;
GRANT CREATE PROCEDURE TO dev;
GRANT CREATE TRIGGER TO dev;
GRANT CREATE TYPE TO dev;
GRANT CREATE OPERATOR TO dev;
GRANT CREATE INDEXTYPE TO dev;

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/31464246/viewspace-2140193/,如需轉載,請註明出處,否則將追究法律責任。

相關文章