topic Get wrong tables when conection to Oracle database in Data Management Questions

Get wrong tables when conection to Oracle database

DenizGueclue — Wed, 08 Feb 2012 15:16:17 GMT

Hello guys!

I've installed ArcSDE and did the post-installation successfully on a RedHat Linux Server. Afterwards I started the default ArcSDE Service (5151)...now when I try to connect with ArcCatalog to the ArcSDE Service I get the tables of an other user of my Orcale database. When deleting the SELECT ANY USER privilege for the SDE user and connect again I can't see any tables but I know the SDE tables exist in the SDE tablespace (when connecting with sqldeveloper as user SDE I can see the geodatabase tables).

Please, do you have a hint?

Thanks,
Dennis

Re: Get wrong tables when conection to Oracle database

VinceAngelo — Wed, 08 Feb 2012 16:09:07 GMT

You should only connect to the database as user SDE if you are doing an upgrade
(at which time, a whole lot more than SELECT ANY TABLE will be necessary).
SELECT ANY TABLE is NOT necessary for the ArcSDE application server to function.

The ArcSDE data dictionary tables are hidden when you connect through ArcGIS
(intentionally, since you shouldn't ever be changing them), but access to them
is necessary for ArcSDE to function.

You should also see all the other tables to which you have been granted at least
SELECT access. In addition, you will see aa list of all featuredatasets, since
these are not database objects and there is no way to determine access without
walking the member list and testing the permissions of all the tables of all the
member featureclasses (very slow).

Nothing you have described matches the "wrong tables" in the title.

- V

Re: Get wrong tables when conection to Oracle database

DenizGueclue — Thu, 09 Feb 2012 07:04:57 GMT

Ok I see...sorry you r right my it was a wrong choice for my title!

Thank you for your clarification!

-Dennis