管理员用户SDE默认权限

SDE用户权限：

-- Create the user
create user SDE
  default tablespace SDE
  temporary tablespace TEMP
  profile DEFAULT
  password expire
  quota unlimited on sde;
-- Grant/Revoke object privileges
grant execute on DBMS_CRYPTO to SDE;
-- Grant/Revoke role privileges
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;

     本文转自stock0991 51CTO博客，原文链接：http://blog.51cto.com/qing0991/1378092，如需转载请自行联系原作者