在 Oracle 中新建 SDE 用户

--1.创建用户(SDE)和密码(SDE)
CREATE USER SDE IDENTIFIED BY SDE
--2.创建表空间(SDE)
CREATE TABLESPACE SDE DATAFILE
‘C:APPTRACINEORADATAORCLSDEDATA01.DBF‘ SIZE 500M AUTOEXTEND ON NEXT 100M MAXSIZE UNLIMITED
LOGGING
EXTENT MANAGEMENT LOCAL AUTOALLOCATE
BLOCKSIZE 8K
SEGMENT SPACE MANAGEMENT AUTO
FLASHBACK ON;
--3.为用户(SDE)赋予权限
GRANT CREATE SESSION to SDE;
GRANT CREATE TABLE to SDE;
GRANT CREATE TABLESPACE to SDE;
GRANT CREATE VIEW to SDE;
GRANT CREATE PROCEDURE to SDE;
GRANT CREATE SEQUENCE to SDE;
GRANT CREATE TRIGGER to SDE;
GRANT CREATE TYPE to SDE;
GRANT CREATE INDEXTYPE to SDE;
GRANT CREATE LIBRARY to SDE;
GRANT CREATE PUBLIC SYNONYM to SDE;
GRANT CREATE OPERATOR to SDE;
GRANT DROP PUBLIC SYNONYM to SDE;
GRANT ADMINISTER DATABASE TRIGGER to SDE;
--4.修改用户(SDE)在表空间(SDE)上限额
ALTER USER SDE QUOTA UNLIMITED ON SDE
--5.
--GRANT EXECUTE ON dbms_pipe TO SDE;
--GRANT EXECUTE ON dbms_lock TO SDE;
--GRANT EXECUTE ON dbms_lob TO SDE;
--GRANT EXECUTE ON dbms_utility TO SDE;
--GRANT EXECUTE ON dbms_sql TO SDE;
--GRANT EXECUTE ON utl_raw TO SDE;

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!