Oracle -- Create User

CREATE USER hibernate IDENTIFIED BY "123"
 DEFAULT TABLESPACE "HIBERNATE"
 TEMPORARY TABLESPACE "TEMP"
 QUOTA UNLIMITED ON "HIBERNATE";

GRANT CREATE JOB TO hibernate WITH ADMIN OPTION;

GRANT CREATE PROCEDURE TO hibernate WITH ADMIN OPTION;

GRANT CREATE SEQUENCE TO hibernate WITH ADMIN OPTION;

GRANT CREATE SESSION TO hibernate WITH ADMIN OPTION;

GRANT CREATE SYNONYM TO hibernate WITH ADMIN OPTION;

GRANT CREATE TABLE TO hibernate WITH ADMIN OPTION;

GRANT CREATE TRIGGER TO hibernate WITH ADMIN OPTION;

GRANT CREATE TYPE TO hibernate WITH ADMIN OPTION;

GRANT CREATE USER TO hibernate WITH ADMIN OPTION;

GRANT CREATE VIEW TO hibernate WITH ADMIN OPTION;

GRANT DELETE ANY TABLE TO hibernate WITH ADMIN OPTION;

GRANT DROP ANY INDEX TO hibernate WITH ADMIN OPTION;

GRANT DROP ANY ROLE TO hibernate WITH ADMIN OPTION;

GRANT DROP ANY SEQUENCE TO hibernate WITH ADMIN OPTION;

GRANT DROP ANY SYNONYM TO hibernate WITH ADMIN OPTION;

GRANT DROP ANY TABLE TO hibernate WITH ADMIN OPTION;

GRANT DROP ANY TRIGGER TO hibernate WITH ADMIN OPTION;

GRANT DROP ANY TYPE TO hibernate WITH ADMIN OPTION;

GRANT DROP ANY VIEW TO hibernate WITH ADMIN OPTION;

GRANT EXECUTE ANY PROCEDURE TO hibernate WITH ADMIN OPTION;

GRANT INSERT ANY TABLE TO hibernate WITH ADMIN OPTION;

GRANT SELECT ANY SEQUENCE TO hibernate WITH ADMIN OPTION;

GRANT SELECT ANY TABLE TO hibernate WITH ADMIN OPTION;

GRANT SELECT ANY TRANSACTION TO hibernate WITH ADMIN OPTION;

GRANT UPDATE ANY TABLE TO hibernate WITH ADMIN OPTION;



posted @ 2017-05-03 11:04  liDB  阅读(617)  评论(0编辑  收藏  举报