EnableEnterpriseGeodatabase的授权语句

最新推荐文章于 2021-12-27 23:24:04 发布

转载最新推荐文章于 2021-12-27 23:24:04 发布 · 1.1k 阅读

文章标签：

#Sde #ArcEngine #ArcGIS #oracle #sql

本文记录了在Oracle数据库中为地理信息系统(GIS)设置企业级地理数据库的过程，包括授予必要的执行权限给公共用户，并创建地理数据库表格及存储过程。但在配置过程中遇到了ST_Geometry形状库路径无效或EXTPROC配置不正确的问题。

语句：

GRANT EXECUTE ON DBMS_PIPE TO public;

GRANT EXECUTE ON DBMS_LOCK TO public;
GRANT EXECUTE ON DBMS_UTILITY TO public;
GRANT EXECUTE ON DBMS_SQL TO public;
GRANT EXECUTE ON DBMS_LOB TO public;
GRANT EXECUTE ON UTL_RAW TO public;
GRANT EXECUTE ON DBMS_CRYPTO TO sde;

结果：
Executing: EnableEnterpriseGeodatabase "Database Connections\Connection to Orcl.sde" F:\20160707安装包\10.2.ecp
Start Time: Wed Nov 23 15:29:45 2016
Validated authorization file.
User has required privileges for geodatabase setup.
XML support is enabled for the database instance.
Created geodatabase tables and stored procedures.
Finished creating geodatabase schema.
The ST_Geometry shape library path may be invalid, or the EXTPROC is not configured correctly in the Oracle instance. [ (Unable to determine current version of ST_SHAPELIB. Please check the ST_Geometry shape library path on the Oracle server, which is set to "c:\progra~2\arcgis\desktop10.2\DatabaseSupport\Oracle\Windows64\st_shapelib.dll". Refer to the ArcGIS help topics for more details.
)]
Succeeded at Wed Nov 23 15:30:12 2016 (Elapsed Time: 27.29 seconds)