Register view with geodatabase fails (view selects table from different user)

by User1973   Last Updated October 10, 2019 18:22 PM

I have two users/schemas in an Oracle 18c geodatabase (10.7.1):

  • USER_A
  • USER_B

Scenario 1:

I create a view in USER_A:

SELECT * FROM USER_A.TEST_TBL.

I am able to successfully register the view with the geodatabase.


Scenario 2:

I create a view in USER_A that selects a table from a different user:

SELECT * FROM USER_B.TEST_TBL.

When I try to register the view with the geodatabase, I get an error:

ERROR 999999: Error executing function
Underlying DBMS error
Failed to execute (RegisterWithGeodatabase)

999999 : Something unexpected caused the tool to fail. Contact Esri
Technical Support (http://esriurl.com/support) to Report a Bug, and refer
to the error help for potential solutions or workarounds.

Why do I get this error?



Answers 1


Using a connection to USER_B:

GRANT SELECT ON USER_B.TEST_TBL  
    TO USER_A WITH GRANT OPTION;
User1973
User1973
October 10, 2019 23:40 PM

Related Questions


Updated January 18, 2019 22:22 PM

Updated August 19, 2018 11:22 AM

Updated March 07, 2019 06:22 AM

Updated June 20, 2018 15:22 PM

Updated May 26, 2017 00:22 AM