Hide system tables from SDE schema

[NathanielWingfield]

I recently installed ArcSDE 9.3 on Oracle 11g. No less than 119 system tables from the APEX_030200 and ORDDATA schemas are showing up in ArcCatalog. Is there an easy solution to make these go away?

[danan]

What about hiding the ArcSDE schema from other users on the instance? At 9.3.1, write privileges (I,U,D) are granted to PUBLIC for GDB_ tables. Read privs are given to most or all tables in the SDE schema. And execute is granted to PUBLIC for all packages and procedures in the SDE schema.

I submitted an idea for hardening the ArcSDE repository to ideas.arcgis.com. Vote on it if you'd like:

http://ideas.arcgis.com/ideaView?id=087300000008HY6AAM

[RussellBrennan]

What about hiding the ArcSDE schema from other users on the instance? At 9.3.1, write privileges (I,U,D) are granted to PUBLIC for GDB_ tables. Read privs are given to most or all tables in the SDE schema. And execute is granted to PUBLIC for all packages and procedures in the SDE schema.

I submitted an idea for hardening the ArcSDE repository to ideas.arcgis.com. Vote on it if you'd like:

http://ideas.arcgis.com/ideaView?id=087300000008HY6AAM

Is this the information you were looking for?
http://resources.arcgis.com/content/kbase?fa=articleShow&d=37824

[danan]

Is this the information you were looking for?
http://resources.arcgis.com/content/kbase?fa=articleShow&d=37824

Thanks Russell. I'll take a look.

[EyadHammad]

we have ArcGIS 10 with SP3 build 3600, yet we face the same problem of having APEX_040000 schema showing in ArcCatalog for all connections. any idea of how to filter it ?

[AJR]

there are two options.  The first is properly administering the privileges on the offending tables (like Vince mentions above).  If that is not an option the second choice is to register the offending tables with SDE and then hide them.  This is done with the sde command line using the sdetable command.

To do this execture the following as the owner of the offending table(s)

sdetable -o register -t some_table -C none -H hidden -u table_owner -p xxx -s yyy -i zzz

The tables will then be hidden from all sde client applications (e.g. ArcGIS)

[ForrestJones]

we have ArcGIS 10 with SP3 build 3600, yet we face the same problem of having APEX_040000 schema showing in ArcCatalog for all connections. any idea of how to filter it ?

Is your ArcSDE database upgraded to 10.0 SP3?

[EyadHammad]

there are two options.  The first is properly administering the privileges on the offending tables (like Vince mentions above).  If that is not an option the second choice is to register the offending tables with SDE and then hide them.  This is done with the sde command line using the sdetable command.

To do this execture the following as the owner of the offending table(s)

sdetable -o register -t some_table -C none -H hidden -u table_owner -p xxx -s yyy -i zzz

The tables will then be hidden from all sde client applications (e.g. ArcGIS)

hmmm , this requires to know the credentials of APEX schema. it was created by the system upon installation i think so how can we get this detail. in addition, its a very long list of tables .. is there a way to deal with a schema as a whole ?

by the way, another schema called LBACSYS is also showing lots of tables that we would love to hide from our users

Is your ArcSDE database upgraded to 10.0 SP3?

no. i am upgrading now

[EyadHammad]

SDE is upgraded to SP3 and geodatabase was upgraded yet situation got worse.

additional system schemas now are showing:

1- APEX_040000
2- APPQOSSYS
3- LBACSYS
4- OWBSYS

how to hide these in ArcCatalog for our users ?

[AJR]

The sdetable command operates on a table by table basis, there isn't any option (that I know of) to hide all the tables from a given schema.  You could script a solution relatively easily using sql to repetitvely call the sdetable command.  Something along the lines of select 'sdetable -o ...-t " || tablename || ' -s server -i ...." from user_tables ought to do the trick (either re-direct the output to a text file that you then execute or save the results to a text file (if using a GUI based tool).

[ForrestJones]

SDE is upgraded to SP3 and geodatabase was upgraded yet situation got worse.

additional system schemas now are showing:

1- APEX_040000
2- APPQOSSYS
3- LBACSYS
4- OWBSYS

how to hide these in ArcCatalog for our users ?

Something doesn't seem correct if they are still showing up and you are up to 10.0 SP3 on the client and sde is upgraded. Will you please contact esri support so we can narrow this down and determine if there is something more we need to fix?

Thanks,