创建用户SQL

rem -------------------SDE---------------
drop user SDE CASCADE;
drop user SDE CASCADE;
rem gisoracle 用于存放用户数据 密码为land
CREATE USER SDE  PROFILE "DEFAULT"    IDENTIFIED BY SDE DEFAULT TABLESPACE USERS     ACCOUNT UNLOCK;
GRANT ALTER ANY INDEX TO SDE;
GRANT ALTER ANY TABLE TO sde;
GRANT ALTER ANY TRIGGER TO sde;
GRANT CREATE ANY TABLE TO sde;
GRANT CREATE ANY TRIGGER TO sde;
GRANT CREATE ANY VIEW TO sde;
GRANT CREATE SEQUENCE TO sde;
GRANT DROP ANY PROCEDURE TO sde;
GRANT DROP ANY TABLE TO sde;
GRANT DROP ANY TRIGGER TO sde;
GRANT DROP ANY VIEW TO sde;
GRANT CREATE PUBLIC SYNONYM TO sde;
GRANT EXECUTE ANY PROCEDURE TO sde;
GRANT SELECT ANY TABLE TO sde;
GRANT CONNECT TO sde;
GRANT DBA TO sde;
GRANT EXP_FULL_DATABASE TO sde;
GRANT IMP_FULL_DATABASE TO sde;
CREATE TABLESPACE SDE     LOGGING     DATAFILE 'SDE.ora' SIZE 256M     EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT  AUTO ;
ALTER USER sde  DEFAULT TABLESPACE sde;

Grant ALTER ANY INDEX To sde;
Grant ALTER ANY TABLE To sde;
Grant ALTER ANY TRIGGER To sde;
Grant CREATE ANY TABLE To sde;
Grant CREATE ANY TRIGGER To sde;
Grant CREATE ANY VIEW To sde;
Grant CREATE SEQUENCE To sde;
Grant DROP ANY PROCEDURE To sde;
Grant DROP ANY TABLE To sde;
Grant DROP ANY TRIGGER To sde;
Grant DROP ANY VIEW To sde;
Grant EXECUTE ANY PROCEDURE To sde;
Grant SELECT ANY TABLE To sde;
Grant UNLIMITED TABLESPACE To sde;
rem landuser 用于存放管理数据库 密码为land
drop user landuser CASCADE;
CREATE USER landuser  PROFILE "DEFAULT" IDENTIFIED BY land DEFAULT TABLESPACE USERS ACCOUNT UNLOCK;
GRANT ALTER ANY INDEX TO landuser;
GRANT ALTER ANY TABLE TO landuser;
GRANT ALTER ANY TRIGGER TO landuser;
GRANT CREATE ANY TABLE TO landuser;
GRANT CREATE ANY TRIGGER TO landuser;
GRANT CREATE ANY VIEW TO landuser;
GRANT CREATE SEQUENCE TO landuser;
GRANT DROP ANY PROCEDURE TO landuser;
GRANT DROP ANY TABLE TO landuser;
GRANT DROP ANY TRIGGER TO landuser;
GRANT DROP ANY VIEW TO landuser;
GRANT EXECUTE ANY PROCEDURE TO landuser;
GRANT SELECT ANY TABLE TO landuser;
GRANT CONNECT TO landuser;
GRANT DBA TO landuser;
GRANT EXP_FULL_DATABASE TO landuser;
GRANT IMP_FULL_DATABASE TO landuser;
GRANT CREATE PUBLIC SYNONYM TO landuser;

GRANT CREATE ANY SYNONYM TO LANDUSER;
GRANT DROP ANY SYNONYM TO LANDUSER;
GRANT CREATE PUBLIC SYNONYM TO LANDUSER;
GRANT DROP PUBLIC SYNONYM TO LANDUSER;
GRANT DELETE ANY  TABLE TO LANDUSER;
CREATE TABLESPACE land     LOGGING     DATAFILE'land.ora' SIZE 256M     EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT  AUTO ;
ALTER USER landuser  DEFAULT TABLESPACE land;
rem gisoracle 用于存放用户数据 密码为land
drop user gisoracle CASCADE;
CREATE USER gisoracle  PROFILE "DEFAULT"    IDENTIFIED BY csland DEFAULT TABLESPACE USERS     ACCOUNT UNLOCK;
GRANT ALTER ANY INDEX TO gisoracle;
GRANT ALTER ANY TABLE TO gisoracle;
GRANT ALTER ANY TRIGGER TO gisoracle;
GRANT CREATE ANY TABLE TO gisoracle;
GRANT CREATE ANY TRIGGER TO gisoracle;
GRANT CREATE ANY VIEW TO gisoracle;
GRANT CREATE SEQUENCE TO gisoracle;
GRANT DROP ANY PROCEDURE TO gisoracle;
GRANT DROP ANY TABLE TO gisoracle;
GRANT DROP ANY TRIGGER TO gisoracle;
GRANT DROP ANY VIEW TO gisoracle;
GRANT CREATE PUBLIC SYNONYM TO gisoracle;
GRANT EXECUTE ANY PROCEDURE TO gisoracle;
GRANT SELECT ANY TABLE TO gisoracle;
GRANT CONNECT TO gisoracle;
GRANT DBA TO gisoracle;
GRANT EXP_FULL_DATABASE TO gisoracle;
GRANT IMP_FULL_DATABASE TO gisoracle;
CREATE TABLESPACE CSland     LOGGING     DATAFILE 'CSland.ora' SIZE 1024M     EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT  AUTO ;
ALTER USER gisoracle  DEFAULT TABLESPACE CSland;

Grant ALTER ANY INDEX To gisoracle;
Grant ALTER ANY TABLE To gisoracle;
Grant ALTER ANY TRIGGER To gisoracle;
Grant CREATE ANY TABLE To gisoracle;
Grant CREATE ANY TRIGGER To gisoracle;
Grant CREATE ANY VIEW To gisoracle;
Grant CREATE SEQUENCE To gisoracle;
Grant DROP ANY PROCEDURE To gisoracle;
Grant DROP ANY TABLE To gisoracle;
Grant DROP ANY TRIGGER To gisoracle;
Grant DROP ANY VIEW To gisoracle;
Grant EXECUTE ANY PROCEDURE To gisoracle;
Grant SELECT ANY TABLE To gisoracle;
Grant UNLIMITED TABLESPACE To gisoracle;
 
exit;