AnsweredAssumed Answered

Users created from Oracle SQL Developer instead of ArcMap

Question asked by gprocino on Mar 26, 2014
Latest reply on Mar 30, 2014 by gprocino
Hi everyone,

I am using an Enterprise Geodatabase implemented under sde10.1 ((SDO_GEOMETRY) + Oracle11gR2 (linux5 -up.7).

I have created my users ADAM (without privilege and role) using Oracle SQL Developer  instead of using the Esri ArcGIS tool 'Create Database User'.

I have granted GEOEDITOR role at ADAM user, using Oracle SQL Developer. Geoeditor role has only Session privileges.


All feature class of geodatabase has been granted to "Geoeditor" role  with view,select, insert, delete privileges.

Now, ADAM is not able to find any feature class within geodatabase.

What am I missing here?


Technical references:
- ArcGIS 10.1 sp1 + qi patch
- ArcSDE 10.1 sp1 (SDO_GEOMETRY) + qi patch on ORACLE

Please help me!

I have another unsolved ploblem on data too (http://forums.arcgis.com/threads/104968-strange-view-of-sde-feature-within-arcgis-desktop?p=374306#post374306)

Thank you

Outcomes