一、针对windows操作系统
1、删除用户SDE
1
drop user SDE cascade
2、删除表空间sde
1
DROP TABLESPACE SDE INCLUDING CONTENTS CASCADE CONSTRAINTS;
3、删除表空间sde文件
D:\app\Administrator\product\11.2.0\dbhome_1\database\sde
二、针对Linux操作系统
1、删除用户SDE：
1
drop user SDE cascade;
2、删除表空间sde
1
DROP TABLESPACE SDE INCLUDING CONTENTS CASCADE CONSTRAINTS;
3、删除表空间sde文件
# cd/u01/app/oracle/product/11.2.0/dbhome_1/dbs/
# rm -rf sde
三、地理数据库管理员sde用户默认权限
-- Create the user
create user SDE
default tablespace SDE
temporary tablespace TEMP
profile DEFAULT
password expire;
-- Grant/Revoke object privileges
grant execute on DBMS_CRYPTO to SDE;
grant execute on DBMS_RLS to SDE;
grant execute on DBMS_SESSION to SDE;
-- Grant/Revoke role privileges
grant connect to SDE;
grant dba to SDE;
grant resource to SDE;
grant select_catalog_role to SDE;
-- Grant/Revoke system privileges
grant administer database trigger to SDE;
grant alter any index to SDE;
grant alter system to SDE;
grant create any index to SDE;
grant create any trigger to SDE;
grant create any view to SDE;
grant create indextype to SDE;
grant create library to SDE;
grant create operator to SDE;
grant create procedure to SDE;
grant create public synonym to SDE;
grant create sequence to SDE;
grant create session to SDE;
grant create table to SDE;
grant create trigger to SDE;
grant create type to SDE;
grant create view to SDE;
grant drop any index to SDE;
grant drop any view to SDE;
grant drop public synonym to SDE;
grant select any table to SDE;
grant unlimited tablespace to SDE;
-- Set the user's default roles
alter user SDE
default role connect, dba, resource;
