删除地理数据库

一、针对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;