AnsweredAssumed Answered

Privileges for User Schema in Geodatabase

Question asked by apurvdanke on Jul 22, 2016
Latest reply on Jul 22, 2016 by George_Thompson-esristaff

Hi all,

 

Really struggling for answers but help is appreciated. We have created a user schema called "LandEnv" in our Oracle Spatial geodatabase. As I am not the DBA, I requested my DBA to assign privileges to the "LandEnv" user in Oracle. Following privileges were provided which is as per the following URL -> Add users to Oracle—Help | ArcGIS for Desktop

 

  • CREATE SESSION
  • CREATE SEQUENCE
  • CREATE TABLE
  • CREATE TRIGGER
  • CREATE VIEW
  • SELECT ON DBA_ROLES

 

However when I connect to my geodatabase using "LandEnv" user in ArcCatalog and try to copy or create a feature class, I get the following error. Can anyone please tell me what is missing? What are the full list of privileges that need to be provided by the DBA to the user?

 

 

We are able to create feature class in SDE schema, but that is not the best practice.

 

Regards,

Apurv

Outcomes