ArcSDE中多user Scheme的实现

安装环境：

win2003

arcsde9.2

oracle9i

安装步骤：

1.创建表空间

 create tablespace aaa  datafile 'C:\oracle\oradata\fzgas\fzisdata.dbf' size 50M  
autoextend on next 10M maxsize unlimited logging  extent management local autoallocate 
segment space management auto;

2.创建用户aaa

 create user aaa 
 identified by "aaa"
 default tablespace aaa
 temporary tablespace TEMP
 profile DEFAULT;

3.授予sde相关权限

3.1 grant connect,resource  to aaa;

3.2 安装sde所需权限（http://webhelp.esri.com/arcgisdesktop/9.3/index.cfm?TopicName=User_permissions_for_geodatabases_in_Oracle）

Privilege	Purpose
CREATE SESSION	Connect to Oracle.
CREATE TABLE CREATE TRIGGER	Create and upgrade ArcSDE repository.
CREATE SEQUENCE	Create sequences when the geodatabase is created.
CREATE PROCEDURE	Create and upgrade packages for maintaining the contents of ArcSDE repository tables.
CREATE INDEXTYPE  CREATE LIBRARY  CREATE OPERATOR  CREATE PUBLIC SYNONYM  CREATE TYPE  CREATE VIEW  DROP PUBLIC SYNONYM	Create the Spatial Type for Oracle (ST_Geometry) user-defined data type. CREATE OPERATOR and CREATE INDEXTYPE are also needed to upgrade ArcSDE. These privileges can be revoked after installation or upgrade.
SELECT ANY TABLE	Autoregistration with the geodatabase of Oracle Spatial layers created by third-party applications and for upgrading geodatabase contents. It is also necessary to perform an upgrade.
ALTER ANY INDEX  ALTER ANY TABLE  ANALYZE ANY  CREATE ANY INDEX  CREATE ANY PROCEDURE  CREATE ANY SEQUENCE  CREATE ANY TRIGGER  CREATE ANY VIEW  DROP ANY INDEX  DROP ANY PROCEDURE  DROP ANY SEQUENCE  DROP ANY TABLE  DROP ANY VIEW  EXECUTE ANY PROCEDURE  SELECT ANY SEQUENCE	Upgrade geodatabase contents.

授予上表中的权限给用户aaa,脚本如下：

grant  CREATE SESSION to aaa;
grant  CREATE TABLE to aaa;
grant  CREATE PROCEDURE to aaa;
grant  CREATE SEQUENCE to aaa;
grant  CREATE TRIGGER to aaa;
grant  CREATE TYPE to aaa;
grant  CREATE LIBRARY to aaa;
grant  CREATE PUBLIC SYNONYM to aaa;
grant  CREATE OPERATOR to aaa;
grant  CREATE INDEXTYPE to aaa;
grant  DROP PUBLIC SYNONYM to aaa;
grant  CREATE VIEW to aaa;
grant  UNLIMITED TABLESPACE to aaa;
grant  ADMINISTER DATABASE TRIGGER to aaa;

3.3 授权 DBMS_PIPE 和 DBMS_LOCK 给 PUBLIC. 


SQL> grant execute on DBMS_PIPE to PUBLIC; 
SQL> grant execute on DBMS_LOCK to PUBLIC; 
SQL> commit; 

3.4 修改下面环境变量,以$SDEHOME/bin:$ORACLE_HOME/bin:开头

PATH :$SDEHOME/bin:$ORACLE_HOME/bin:... 
LD_LIBRARY_PATH :$SDEHOME/lib:$ORACLE_HOME/lib:... 

4.安装sde服务

sdesetup -o install -d ORACLE9I -i 5151:aaa -u aaa -p aaa  -D fzgas

5.测试连接

使用arccatalog创建空间链接，用户名密码均设置为aaa,测试连接。

导入要素类后，要素类的前缀为aaa,而不是bbb