Community
Select to view content in your preferred language

Hide system tables from SDE schema

7664
20
04-09-2010 05:53 AM
NathanielWingfield
by
Deactivated User
‎04-09-2010 05:53 AM
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?
20 Replies
BojanBukovic
by
Deactivated User
‎05-10-2012 12:29 AM
Hi all,

objects are not displaying in ArcCatalog anymore after revoking select on tables from public role in my case.
Using ArcSDE 10 SP4.

revoke select on lbacsys.all_sa_audit_options from public;
revoke select on lbacsys.all_sa_compartments from public;
revoke select on lbacsys.all_sa_data_labels from public;
revoke select on lbacsys.all_sa_group_hierarchy from public;
revoke select on lbacsys.all_sa_groups from public;
revoke select on lbacsys.all_sa_labels from public;
revoke select on lbacsys.all_sa_levels from public;
revoke select on lbacsys.all_sa_policies from public;
revoke select on lbacsys.all_sa_prog_privs from public;
revoke select on lbacsys.all_sa_schema_policies from public;
revoke select on lbacsys.all_sa_table_policies from public;
revoke select on lbacsys.all_sa_user_compartments from public;
revoke select on lbacsys.all_sa_user_groups from public;
revoke select on lbacsys.all_sa_user_labels from public;
revoke select on lbacsys.all_sa_user_levels from public;
revoke select on lbacsys.all_sa_user_privs from public;
revoke select on lbacsys.all_sa_users from public;
revoke select on lbacsys.lbacaudit_actions from public;
revoke select on lbacsys.lbac_audit_actions from public;
revoke select on lbacsys.user_sa_session from public;



Regards
0 Kudos