Privileges for Oracle users created using Create Database User tool

[JonathanBailey]

I've created an enterprise geodatabase on Oracle. I can connect to it from ArcCatalog and from SQL Developer using the SDE user.

I've created a new user named GFPTest using the Create Database User tool, choosing the defaults for Role and Tablespace Name.

I can connect to the database in ArcCatalog using the GFPTest user. However, when I connect in SQL Developer using the GFPTest user, I can't see any tables.

Is there something in creating the database user that I've missed?

Thanks,

Jon.

[VinceAngelo]

You didn't include the query output.

You should also provide the version (and service pack) or ArcGIS and ArcSDE.

I have seen scrambled permissions before, but it's not a regular event.

- V

[JonathanBailey]

"GRANTEE","OWNER","TABLE_NAME","GRANTOR","PRIVILEGE","GRANTABLE","HIERARCHY"

"PUBLIC","SDE","ALL_ST_GEOMETRY_COLUMNS_V","SDE","DELETE","NO","NO"

"PUBLIC","SDE","ALL_ST_GEOMETRY_COLUMNS_V","SDE","INSERT","NO","NO"

"PUBLIC","SDE","ALL_ST_GEOMETRY_COLUMNS_V","SDE","SELECT","NO","NO"

"PUBLIC","SDE","ALL_ST_GEOMETRY_COLUMNS_V","SDE","UPDATE","NO","NO"

"PUBLIC","SDE","ARCHIVE_UTIL","SDE","EXECUTE","YES","NO"

"PUBLIC","SDE","BLOB_ARRAY_TAB","SDE","EXECUTE","NO","NO"

"PUBLIC","SDE","BND_ROWID_TAB","SDE","EXECUTE","NO","NO"

"PUBLIC","SDE","COLUMN_REGISTRY","SDE","SELECT","NO","NO"

"PUBLIC","SDE","CONNECTION_ID_GENERATOR","SDE","SELECT","NO","NO"

"PUBLIC","SDE","DBTUNE","SDE","SELECT","NO","NO"

"PUBLIC","SDE","DBTUNE_UTIL","SDE","EXECUTE","YES","NO"

"PUBLIC","SDE","FLT_ARRAY_TAB","SDE","EXECUTE","NO","NO"

"PUBLIC","SDE","GDB_ITEMRELATIONSHIPS","SDE","DELETE","YES","NO"

"PUBLIC","SDE","GDB_ITEMRELATIONSHIPS","SDE","INSERT","YES","NO"

"PUBLIC","SDE","GDB_ITEMRELATIONSHIPS","SDE","SELECT","YES","NO"

"PUBLIC","SDE","GDB_ITEMRELATIONSHIPS","SDE","UPDATE","YES","NO"

"PUBLIC","SDE","GDB_ITEMRELATIONSHIPS_VW","SDE","UPDATE","YES","NO"

"PUBLIC","SDE","GDB_ITEMRELATIONSHIPS_VW","SDE","SELECT","YES","NO"

"PUBLIC","SDE","GDB_ITEMRELATIONSHIPS_VW","SDE","INSERT","YES","NO"

"PUBLIC","SDE","GDB_ITEMRELATIONSHIPS_VW","SDE","DELETE","YES","NO"

"PUBLIC","SDE","GDB_ITEMRELATIONSHIPTYPES","SDE","DELETE","YES","NO"

"PUBLIC","SDE","GDB_ITEMRELATIONSHIPTYPES","SDE","INSERT","YES","NO"

"PUBLIC","SDE","GDB_ITEMRELATIONSHIPTYPES","SDE","SELECT","YES","NO"

"PUBLIC","SDE","GDB_ITEMRELATIONSHIPTYPES","SDE","UPDATE","YES","NO"

"PUBLIC","SDE","GDB_ITEMS","SDE","INSERT","YES","NO"

"PUBLIC","SDE","GDB_ITEMS","SDE","UPDATE","YES","NO"

"PUBLIC","SDE","GDB_ITEMS","SDE","DELETE","YES","NO"

"PUBLIC","SDE","GDB_ITEMS","SDE","SELECT","YES","NO"

"PUBLIC","SDE","GDB_ITEMS_VW","SDE","SELECT","YES","NO"

"PUBLIC","SDE","GDB_ITEMS_VW","SDE","DELETE","YES","NO"

"PUBLIC","SDE","GDB_ITEMS_VW","SDE","INSERT","YES","NO"

"PUBLIC","SDE","GDB_ITEMS_VW","SDE","UPDATE","YES","NO"

"PUBLIC","SDE","GDB_ITEMTYPES","SDE","INSERT","YES","NO"

"PUBLIC","SDE","GDB_ITEMTYPES","SDE","SELECT","YES","NO"

"PUBLIC","SDE","GDB_ITEMTYPES","SDE","DELETE","YES","NO"

"PUBLIC","SDE","GDB_ITEMTYPES","SDE","UPDATE","YES","NO"

"PUBLIC","SDE","GDB_REPLICALOG","SDE","INSERT","YES","NO"

"PUBLIC","SDE","GDB_REPLICALOG","SDE","DELETE","YES","NO"

"PUBLIC","SDE","GDB_REPLICALOG","SDE","UPDATE","YES","NO"

"PUBLIC","SDE","GDB_REPLICALOG","SDE","SELECT","YES","NO"

"PUBLIC","SDE","GDB_TABLES_LAST_MODIFIED","SDE","SELECT","YES","NO"

"PUBLIC","SDE","GDB_TABLES_LAST_MODIFIED","SDE","INSERT","YES","NO"

"PUBLIC","SDE","GDB_TABLES_LAST_MODIFIED","SDE","DELETE","YES","NO"

"PUBLIC","SDE","GDB_TABLES_LAST_MODIFIED","SDE","UPDATE","YES","NO"

"PUBLIC","SDE","GDB_UTIL","SDE","EXECUTE","YES","NO"

"PUBLIC","SDE","GEOMETRY_COLUMNS","SDE","SELECT","NO","NO"

"PUBLIC","SDE","INSTANCES","SDE","DELETE","NO","NO"

"PUBLIC","SDE","INSTANCES","SDE","INSERT","NO","NO"

"PUBLIC","SDE","INSTANCES","SDE","SELECT","NO","NO"

"PUBLIC","SDE","INSTANCES","SDE","UPDATE","NO","NO"

"PUBLIC","SDE","INSTANCES_UTIL","SDE","EXECUTE","YES","NO"

"PUBLIC","SDE","INSTANCE_ID_GENERATOR","SDE","SELECT","NO","NO"

"PUBLIC","SDE","INT_ARRAY_TAB","SDE","EXECUTE","NO","NO"

"PUBLIC","SDE","KEYSET_UTIL","SDE","EXECUTE","YES","NO"

"PUBLIC","SDE","LAYERS","SDE","SELECT","NO","NO"

"PUBLIC","SDE","LAYERS_UTIL","SDE","EXECUTE","YES","NO"

"PUBLIC","SDE","LAYER_ID_GENERATOR","SDE","SELECT","NO","NO"

"PUBLIC","SDE","LAYER_LOCKS","SDE","SELECT","NO","NO"

"PUBLIC","SDE","LAYER_STATS_UTIL","SDE","EXECUTE","YES","NO"

"PUBLIC","SDE","LINEAGES_MODIFIED","SDE","SELECT","NO","NO"

"PUBLIC","SDE","LOCATORS","SDE","SELECT","NO","NO"

"PUBLIC","SDE","LOCATOR_ID_GENERATOR","SDE","SELECT","NO","NO"

"PUBLIC","SDE","LOCATOR_UTIL","SDE","EXECUTE","YES","NO"

"PUBLIC","SDE","LOCK_UTIL","SDE","EXECUTE","YES","NO"

"PUBLIC","SDE","LOGFILE_UTIL","SDE","EXECUTE","YES","NO"

"PUBLIC","SDE","METADATA","SDE","SELECT","NO","NO"

"PUBLIC","SDE","METADATA_ID_GENERATOR","SDE","SELECT","NO","NO"

"PUBLIC","SDE","METADATA_UTIL","SDE","EXECUTE","YES","NO"

"PUBLIC","SDE","MVTABLES_MODIFIED","SDE","SELECT","NO","NO"

"PUBLIC","SDE","OBJECT_LOCKS","SDE","SELECT","NO","NO"

"PUBLIC","SDE","PINFO_UTIL","SDE","EXECUTE","YES","NO"

"PUBLIC","SDE","PROCESS_INFORMATION","SDE","SELECT","NO","NO"

"PUBLIC","SDE","R100","SDE","SELECT","NO","NO"

"PUBLIC","SDE","R101","SDE","SELECT","NO","NO"

"PUBLIC","SDE","R102","SDE","SELECT","NO","NO"

"PUBLIC","SDE","R103","SDE","SELECT","NO","NO"

"PUBLIC","SDE","R104","SDE","SELECT","NO","NO"

"PUBLIC","SDE","R105","SDE","SELECT","NO","NO"

"PUBLIC","SDE","R106","SDE","SELECT","NO","NO"

"PUBLIC","SDE","R107","SDE","SELECT","NO","NO"

"PUBLIC","SDE","R108","SDE","SELECT","NO","NO"

"PUBLIC","SDE","R109","SDE","SELECT","NO","NO"

"PUBLIC","SDE","R110","SDE","SELECT","NO","NO"

"PUBLIC","SDE","R111","SDE","SELECT","NO","NO"

"PUBLIC","SDE","R112","SDE","SELECT","NO","NO"

"PUBLIC","SDE","R113","SDE","SELECT","NO","NO"

"PUBLIC","SDE","R114","SDE","SELECT","NO","NO"

"PUBLIC","SDE","R115","SDE","SELECT","NO","NO"

"PUBLIC","SDE","R116","SDE","SELECT","NO","NO"

"PUBLIC","SDE","R117","SDE","SELECT","NO","NO"

"PUBLIC","SDE","R118","SDE","SELECT","NO","NO"

"PUBLIC","SDE","R119","SDE","SELECT","NO","NO"

"PUBLIC","SDE","R120","SDE","SELECT","NO","NO"

"PUBLIC","SDE","R122","SDE","SELECT","NO","NO"

"PUBLIC","SDE","R123","SDE","SELECT","NO","NO"

"PUBLIC","SDE","R124","SDE","SELECT","NO","NO"

"PUBLIC","SDE","R125","SDE","SELECT","NO","NO"

"PUBLIC","SDE","R126","SDE","SELECT","NO","NO"

"PUBLIC","SDE","R127","SDE","SELECT","NO","NO"

"PUBLIC","SDE","R128","SDE","SELECT","NO","NO"

"PUBLIC","SDE","R129","SDE","SELECT","NO","NO"

"PUBLIC","SDE","R130","SDE","SELECT","NO","NO"

"PUBLIC","SDE","R131","SDE","SELECT","NO","NO"

"PUBLIC","SDE","R132","SDE","SELECT","NO","NO"

"PUBLIC","SDE","R133","SDE","SELECT","NO","NO"

"PUBLIC","SDE","R134","SDE","SELECT","NO","NO"

"PUBLIC","SDE","R135","SDE","SELECT","NO","NO"

"PUBLIC","SDE","R136","SDE","SELECT","NO","NO"

"PUBLIC","SDE","R137","SDE","SELECT","NO","NO"

"PUBLIC","SDE","R138","SDE","SELECT","NO","NO"

"PUBLIC","SDE","R139","SDE","SELECT","NO","NO"

"PUBLIC","SDE","R140","SDE","SELECT","NO","NO"

"PUBLIC","SDE","R141","SDE","SELECT","NO","NO"

"PUBLIC","SDE","R142","SDE","SELECT","NO","NO"

"PUBLIC","SDE","R143","SDE","SELECT","NO","NO"

"PUBLIC","SDE","R144","SDE","SELECT","NO","NO"

"PUBLIC","SDE","R145","SDE","SELECT","NO","NO"

"PUBLIC","SDE","R146","SDE","SELECT","NO","NO"

"PUBLIC","SDE","R147","SDE","SELECT","NO","NO"

"PUBLIC","SDE","R148","SDE","SELECT","NO","NO"

"PUBLIC","SDE","R149","SDE","SELECT","NO","NO"

"PUBLIC","SDE","R150","SDE","SELECT","NO","NO"

"PUBLIC","SDE","R151","SDE","SELECT","NO","NO"

"PUBLIC","SDE","R152","SDE","SELECT","NO","NO"

"PUBLIC","SDE","R153","SDE","SELECT","NO","NO"

"PUBLIC","SDE","R154","SDE","SELECT","NO","NO"

"PUBLIC","SDE","R155","SDE","SELECT","NO","NO"

"PUBLIC","SDE","R156","SDE","SELECT","NO","NO"

"PUBLIC","SDE","R157","SDE","SELECT","NO","NO"

"PUBLIC","SDE","R158","SDE","SELECT","NO","NO"

"PUBLIC","SDE","R159","SDE","SELECT","NO","NO"

"PUBLIC","SDE","R160","SDE","SELECT","NO","NO"

"PUBLIC","SDE","R161","SDE","SELECT","NO","NO"

"PUBLIC","SDE","R162","SDE","SELECT","NO","NO"

"PUBLIC","SDE","R163","SDE","SELECT","NO","NO"

"PUBLIC","SDE","R164","SDE","SELECT","NO","NO"

"PUBLIC","SDE","R165","SDE","SELECT","NO","NO"

"PUBLIC","SDE","R166","SDE","SELECT","NO","NO"

"PUBLIC","SDE","R167","SDE","SELECT","NO","NO"

"PUBLIC","SDE","R168","SDE","SELECT","NO","NO"

"PUBLIC","SDE","R169","SDE","SELECT","NO","NO"

"PUBLIC","SDE","R170","SDE","SELECT","NO","NO"

"PUBLIC","SDE","R171","SDE","SELECT","NO","NO"

"PUBLIC","SDE","R172","SDE","SELECT","NO","NO"

"PUBLIC","SDE","R173","SDE","SELECT","NO","NO"

"PUBLIC","SDE","R175","SDE","SELECT","NO","NO"

"PUBLIC","SDE","R176","SDE","SELECT","NO","NO"

"PUBLIC","SDE","R177","SDE","SELECT","NO","NO"

"PUBLIC","SDE","R178","SDE","SELECT","NO","NO"

"PUBLIC","SDE","R179","SDE","SELECT","NO","NO"

"PUBLIC","SDE","R180","SDE","SELECT","NO","NO"

"PUBLIC","SDE","R181","SDE","SELECT","NO","NO"

"PUBLIC","SDE","R182","SDE","SELECT","NO","NO"

"PUBLIC","SDE","R183","SDE","SELECT","NO","NO"

"PUBLIC","SDE","R184","SDE","SELECT","NO","NO"

"PUBLIC","SDE","R185","SDE","SELECT","NO","NO"

"PUBLIC","SDE","R186","SDE","SELECT","NO","NO"

"PUBLIC","SDE","R187","SDE","SELECT","NO","NO"

"PUBLIC","SDE","R188","SDE","SELECT","NO","NO"

"PUBLIC","SDE","R189","SDE","SELECT","NO","NO"

"PUBLIC","SDE","R190","SDE","SELECT","NO","NO"

"PUBLIC","SDE","R191","SDE","SELECT","NO","NO"

"PUBLIC","SDE","R192","SDE","SELECT","NO","NO"

"PUBLIC","SDE","R193","SDE","SELECT","NO","NO"

"PUBLIC","SDE","R194","SDE","SELECT","NO","NO"

"PUBLIC","SDE","R195","SDE","SELECT","NO","NO"

"PUBLIC","SDE","R196","SDE","SELECT","NO","NO"

"PUBLIC","SDE","R2","SDE","SELECT","NO","NO"

"PUBLIC","SDE","R25","SDE","SELECT","NO","NO"

"PUBLIC","SDE","R26","SDE","SELECT","NO","NO"

"PUBLIC","SDE","R27","SDE","SELECT","NO","NO"

"PUBLIC","SDE","R28","SDE","SELECT","NO","NO"

"PUBLIC","SDE","R29","SDE","SELECT","NO","NO"

"PUBLIC","SDE","R3","SDE","SELECT","NO","NO"

"PUBLIC","SDE","R30","SDE","SELECT","NO","NO"

"PUBLIC","SDE","R31","SDE","SELECT","NO","NO"

"PUBLIC","SDE","R32","SDE","SELECT","NO","NO"

"PUBLIC","SDE","R33","SDE","SELECT","NO","NO"

"PUBLIC","SDE","R34","SDE","SELECT","NO","NO"

"PUBLIC","SDE","R35","SDE","SELECT","NO","NO"

"PUBLIC","SDE","R36","SDE","SELECT","NO","NO"

"PUBLIC","SDE","R37","SDE","SELECT","NO","NO"

"PUBLIC","SDE","R38","SDE","SELECT","NO","NO"

"PUBLIC","SDE","R39","SDE","SELECT","NO","NO"

"PUBLIC","SDE","R4","SDE","SELECT","NO","NO"

"PUBLIC","SDE","R40","SDE","SELECT","NO","NO"

"PUBLIC","SDE","R41","SDE","SELECT","NO","NO"

"PUBLIC","SDE","R42","SDE","SELECT","NO","NO"

"PUBLIC","SDE","R43","SDE","SELECT","NO","NO"

"PUBLIC","SDE","R44","SDE","SELECT","NO","NO"

[JonathanBailey]

"PUBLIC","SDE","R45","SDE","SELECT","NO","NO"

"PUBLIC","SDE","R46","SDE","SELECT","NO","NO"

"PUBLIC","SDE","R47","SDE","SELECT","NO","NO"

"PUBLIC","SDE","R48","SDE","SELECT","NO","NO"

"PUBLIC","SDE","R49","SDE","SELECT","NO","NO"

"PUBLIC","SDE","R5","SDE","SELECT","NO","NO"

"PUBLIC","SDE","R50","SDE","SELECT","NO","NO"

"PUBLIC","SDE","R51","SDE","SELECT","NO","NO"

"PUBLIC","SDE","R52","SDE","SELECT","NO","NO"

"PUBLIC","SDE","R53","SDE","SELECT","NO","NO"

"PUBLIC","SDE","R54","SDE","SELECT","NO","NO"

"PUBLIC","SDE","R55","SDE","SELECT","NO","NO"

"PUBLIC","SDE","R56","SDE","SELECT","NO","NO"

"PUBLIC","SDE","R57","SDE","SELECT","NO","NO"

"PUBLIC","SDE","R58","SDE","SELECT","NO","NO"

"PUBLIC","SDE","R59","SDE","SELECT","NO","NO"

"PUBLIC","SDE","R6","SDE","SELECT","NO","NO"

"PUBLIC","SDE","R60","SDE","SELECT","NO","NO"

"PUBLIC","SDE","R61","SDE","SELECT","NO","NO"

"PUBLIC","SDE","R99","SDE","SELECT","NO","NO"

"PUBLIC","SDE","RASTERCOLUMNS_UTIL","SDE","EXECUTE","YES","NO"

"PUBLIC","SDE","RASTERCOLUMN_ID_GENERATOR","SDE","SELECT","NO","NO"

"PUBLIC","SDE","RASTER_COLUMNS","SDE","SELECT","NO","NO"

"PUBLIC","SDE","REGISTRY_UTIL","SDE","EXECUTE","YES","NO"

"PUBLIC","SDE","SDENUMTAB","SDE","EXECUTE","NO","NO"

"PUBLIC","SDE","SDEXMLTOTEXT","SDE","EXECUTE","YES","NO"

"PUBLIC","SDE","SDE_ARCHIVES","SDE","SELECT","NO","NO"

"PUBLIC","SDE","SDE_BID_1","SDE","SELECT","NO","NO"

"PUBLIC","SDE","SDE_BID_10","SDE","SELECT","NO","NO"

"PUBLIC","SDE","SDE_BID_11","SDE","SELECT","NO","NO"

"PUBLIC","SDE","SDE_BID_12","SDE","SELECT","NO","NO"

"PUBLIC","SDE","SDE_BID_13","SDE","SELECT","NO","NO"

"PUBLIC","SDE","SDE_BID_14","SDE","SELECT","NO","NO"

"PUBLIC","SDE","SDE_BID_15","SDE","SELECT","NO","NO"

"PUBLIC","SDE","SDE_BID_16","SDE","SELECT","NO","NO"

"PUBLIC","SDE","SDE_BID_17","SDE","SELECT","NO","NO"

"PUBLIC","SDE","SDE_BID_18","SDE","SELECT","NO","NO"

"PUBLIC","SDE","SDE_BID_19","SDE","SELECT","NO","NO"

"PUBLIC","SDE","SDE_BID_2","SDE","SELECT","NO","NO"

"PUBLIC","SDE","SDE_BID_20","SDE","SELECT","NO","NO"

"PUBLIC","SDE","SDE_BID_21","SDE","SELECT","NO","NO"

"PUBLIC","SDE","SDE_BID_22","SDE","SELECT","NO","NO"

"PUBLIC","SDE","SDE_BID_23","SDE","SELECT","NO","NO"

"PUBLIC","SDE","SDE_BID_24","SDE","SELECT","NO","NO"

"PUBLIC","SDE","SDE_BID_25","SDE","SELECT","NO","NO"

"PUBLIC","SDE","SDE_BID_26","SDE","SELECT","NO","NO"

"PUBLIC","SDE","SDE_BID_27","SDE","SELECT","NO","NO"

"PUBLIC","SDE","SDE_BID_28","SDE","SELECT","NO","NO"

"PUBLIC","SDE","SDE_BID_29","SDE","SELECT","NO","NO"

"PUBLIC","SDE","SDE_BID_3","SDE","SELECT","NO","NO"

"PUBLIC","SDE","SDE_BID_30","SDE","SELECT","NO","NO"

"PUBLIC","SDE","SDE_BID_31","SDE","SELECT","NO","NO"

"PUBLIC","SDE","SDE_BID_32","SDE","SELECT","NO","NO"

"PUBLIC","SDE","SDE_BID_33","SDE","SELECT","NO","NO"

"PUBLIC","SDE","SDE_BID_4","SDE","SELECT","NO","NO"

"PUBLIC","SDE","SDE_BID_5","SDE","SELECT","NO","NO"

"PUBLIC","SDE","SDE_BID_6","SDE","SELECT","NO","NO"

"PUBLIC","SDE","SDE_BID_7","SDE","SELECT","NO","NO"

"PUBLIC","SDE","SDE_BID_8","SDE","SELECT","NO","NO"

"PUBLIC","SDE","SDE_BID_9","SDE","SELECT","NO","NO"

"PUBLIC","SDE","SDE_LAYER_STATS","SDE","SELECT","NO","NO"

"PUBLIC","SDE","SDE_LOGFILE_POOL","SDE","SELECT","NO","NO"

"PUBLIC","SDE","SDE_RID_1","SDE","SELECT","NO","NO"

"PUBLIC","SDE","SDE_RID_10","SDE","SELECT","NO","NO"

"PUBLIC","SDE","SDE_RID_11","SDE","SELECT","NO","NO"

"PUBLIC","SDE","SDE_RID_12","SDE","SELECT","NO","NO"

"PUBLIC","SDE","SDE_RID_13","SDE","SELECT","NO","NO"

"PUBLIC","SDE","SDE_RID_14","SDE","SELECT","NO","NO"

"PUBLIC","SDE","SDE_RID_15","SDE","SELECT","NO","NO"

"PUBLIC","SDE","SDE_RID_16","SDE","SELECT","NO","NO"

"PUBLIC","SDE","SDE_RID_17","SDE","SELECT","NO","NO"

"PUBLIC","SDE","SDE_RID_18","SDE","SELECT","NO","NO"

"PUBLIC","SDE","SDE_RID_19","SDE","SELECT","NO","NO"

"PUBLIC","SDE","SDE_RID_2","SDE","SELECT","NO","NO"

"PUBLIC","SDE","SDE_RID_20","SDE","SELECT","NO","NO"

"PUBLIC","SDE","SDE_RID_21","SDE","SELECT","NO","NO"

"PUBLIC","SDE","SDE_RID_22","SDE","SELECT","NO","NO"

"PUBLIC","SDE","SDE_RID_23","SDE","SELECT","NO","NO"

"PUBLIC","SDE","SDE_RID_24","SDE","SELECT","NO","NO"

"PUBLIC","SDE","SDE_RID_25","SDE","SELECT","NO","NO"

"PUBLIC","SDE","SDE_RID_26","SDE","SELECT","NO","NO"

"PUBLIC","SDE","SDE_RID_27","SDE","SELECT","NO","NO"

"PUBLIC","SDE","SDE_RID_28","SDE","SELECT","NO","NO"

"PUBLIC","SDE","SDE_RID_29","SDE","SELECT","NO","NO"

"PUBLIC","SDE","SDE_RID_3","SDE","SELECT","NO","NO"

"PUBLIC","SDE","SDE_RID_30","SDE","SELECT","NO","NO"

"PUBLIC","SDE","SDE_RID_31","SDE","SELECT","NO","NO"

"PUBLIC","SDE","SDE_RID_32","SDE","SELECT","NO","NO"

"PUBLIC","SDE","SDE_RID_33","SDE","SELECT","NO","NO"

"PUBLIC","SDE","SDE_RID_4","SDE","SELECT","NO","NO"

"PUBLIC","SDE","SDE_RID_5","SDE","SELECT","NO","NO"

"PUBLIC","SDE","SDE_RID_6","SDE","SELECT","NO","NO"

"PUBLIC","SDE","SDE_RID_7","SDE","SELECT","NO","NO"

"PUBLIC","SDE","SDE_RID_8","SDE","SELECT","NO","NO"

"PUBLIC","SDE","SDE_RID_9","SDE","SELECT","NO","NO"

"PUBLIC","SDE","SDE_TABLES_MODIFIED","SDE","SELECT","NO","NO"

"PUBLIC","SDE","SDE_TABLES_MODIFIED","SDE","UPDATE","NO","NO"

"PUBLIC","SDE","SDE_UTIL","SDE","EXECUTE","YES","NO"

"PUBLIC","SDE","SDE_XML_COLUMNS","SDE","SELECT","NO","NO"

"PUBLIC","SDE","SDE_XML_DOC1","SDE","DELETE","YES","NO"

"PUBLIC","SDE","SDE_XML_DOC1","SDE","INSERT","YES","NO"

"PUBLIC","SDE","SDE_XML_DOC1","SDE","SELECT","YES","NO"

"PUBLIC","SDE","SDE_XML_DOC1","SDE","UPDATE","YES","NO"

"PUBLIC","SDE","SDE_XML_DOC2","SDE","INSERT","YES","NO"

"PUBLIC","SDE","SDE_XML_DOC2","SDE","UPDATE","YES","NO"

"PUBLIC","SDE","SDE_XML_DOC2","SDE","SELECT","YES","NO"

"PUBLIC","SDE","SDE_XML_DOC2","SDE","DELETE","YES","NO"

"PUBLIC","SDE","SDE_XML_DOC3","SDE","INSERT","YES","NO"

"PUBLIC","SDE","SDE_XML_DOC3","SDE","SELECT","YES","NO"

"PUBLIC","SDE","SDE_XML_DOC3","SDE","DELETE","YES","NO"

"PUBLIC","SDE","SDE_XML_DOC3","SDE","UPDATE","YES","NO"

"PUBLIC","SDE","SDE_XML_DOC4","SDE","DELETE","YES","NO"

"PUBLIC","SDE","SDE_XML_DOC4","SDE","SELECT","YES","NO"

"PUBLIC","SDE","SDE_XML_DOC4","SDE","INSERT","YES","NO"

"PUBLIC","SDE","SDE_XML_DOC4","SDE","UPDATE","YES","NO"

"PUBLIC","SDE","SDE_XML_INDEXES","SDE","SELECT","NO","NO"

"PUBLIC","SDE","SDE_XML_INDEX_TAGS","SDE","SELECT","NO","NO"

"PUBLIC","SDE","SDO_UTIL","SDE","EXECUTE","YES","NO"

"PUBLIC","SDE","SERVER_CONFIG","SDE","SELECT","NO","NO"

"PUBLIC","SDE","SPATIAL_REFERENCES","SDE","SELECT","NO","NO"

"PUBLIC","SDE","SPX_UTIL","SDE","EXECUTE","YES","NO"

"PUBLIC","SDE","SP_GRID_INFO","SDE","EXECUTE","YES","NO"

"PUBLIC","SDE","SREF_UTIL","SDE","EXECUTE","YES","NO"

"PUBLIC","SDE","STATES","SDE","SELECT","NO","NO"

"PUBLIC","SDE","STATE_LINEAGES","SDE","SELECT","NO","NO"

"PUBLIC","SDE","STATE_LOCKS","SDE","SELECT","NO","NO"

"PUBLIC","SDE","ST_AGGR_CONVEXHULL","SDE","EXECUTE","NO","NO"

"PUBLIC","SDE","ST_AGGR_INTERSECTION","SDE","EXECUTE","NO","NO"

"PUBLIC","SDE","ST_AGGR_UNION","SDE","EXECUTE","NO","NO"

"PUBLIC","SDE","ST_AREA","SDE","EXECUTE","YES","NO"

"PUBLIC","SDE","ST_ASBINARY","SDE","EXECUTE","YES","NO"

"PUBLIC","SDE","ST_ASTEXT","SDE","EXECUTE","YES","NO"

"PUBLIC","SDE","ST_BOUNDARY","SDE","EXECUTE","YES","NO"

"PUBLIC","SDE","ST_BUFFER","SDE","EXECUTE","YES","NO"

"PUBLIC","SDE","ST_BUFFER_INTERSECTS","SDE","EXECUTE","NO","NO"

"PUBLIC","SDE","ST_CENTROID","SDE","EXECUTE","YES","NO"

"PUBLIC","SDE","ST_CONTAINS","SDE","EXECUTE","YES","NO"

"PUBLIC","SDE","ST_CONVEXHULL","SDE","EXECUTE","YES","NO"

"PUBLIC","SDE","ST_COORDDIM","SDE","EXECUTE","YES","NO"

[JonathanBailey]

"PUBLIC","SDE","ST_COORDINATE_SYSTEMS","SDE","SELECT","YES","NO"

"PUBLIC","SDE","ST_CREF_UTIL","SDE","EXECUTE","YES","NO"

"PUBLIC","SDE","ST_CROSSES","SDE","EXECUTE","YES","NO"

"PUBLIC","SDE","ST_CURVE","SDE","EXECUTE","YES","NO"

"PUBLIC","SDE","ST_DIFFERENCE","SDE","EXECUTE","YES","NO"

"PUBLIC","SDE","ST_DIMENSION","SDE","EXECUTE","YES","NO"

"PUBLIC","SDE","ST_DISJOINT","SDE","EXECUTE","YES","NO"

"PUBLIC","SDE","ST_DISTANCE","SDE","EXECUTE","YES","NO"

"PUBLIC","SDE","ST_DOMAIN_METHODS","SDE","EXECUTE","YES","NO"

"PUBLIC","SDE","ST_DOMAIN_OPERATORS","SDE","EXECUTE","YES","NO"

"PUBLIC","SDE","ST_DOMAIN_STATS","SDE","EXECUTE","YES","NO"

"PUBLIC","SDE","ST_ENDPOINT","SDE","EXECUTE","YES","NO"

"PUBLIC","SDE","ST_ENTITY","SDE","EXECUTE","YES","NO"

"PUBLIC","SDE","ST_ENVELOPE","SDE","EXECUTE","YES","NO"

"PUBLIC","SDE","ST_ENVINTERSECTS","SDE","EXECUTE","YES","NO"

"PUBLIC","SDE","ST_EQUALS","SDE","EXECUTE","YES","NO"

"PUBLIC","SDE","ST_EXTERIORRING","SDE","EXECUTE","YES","NO"

"PUBLIC","SDE","ST_FUNCS_ARRAY","SDE","DEBUG","YES","NO"

"PUBLIC","SDE","ST_FUNCS_ARRAY","SDE","EXECUTE","YES","NO"

"PUBLIC","SDE","ST_GEOMCOLLECTION","SDE","EXECUTE","YES","NO"

"PUBLIC","SDE","ST_GEOMETRY","SDE","EXECUTE","YES","NO"

"PUBLIC","SDE","ST_GEOMETRYN","SDE","EXECUTE","YES","NO"

[JonathanBailey]

"PUBLIC","SDE","ST_GEOMETRYTYPE","SDE","EXECUTE","YES","NO"

"PUBLIC","SDE","ST_GEOMETRY_COLUMNS","SDE","SELECT","YES","NO"

"PUBLIC","SDE","ST_GEOMETRY_INDEX","SDE","UPDATE","NO","NO"

"PUBLIC","SDE","ST_GEOMETRY_INDEX","SDE","INSERT","NO","NO"

"PUBLIC","SDE","ST_GEOMETRY_INDEX","SDE","DELETE","NO","NO"

"PUBLIC","SDE","ST_GEOMETRY_INDEX","SDE","SELECT","NO","NO"

"PUBLIC","SDE","ST_GEOMETRY_OPERATORS","SDE","EXECUTE","YES","NO"

"PUBLIC","SDE","ST_GEOMETRY_SHAPELIB_PKG","SDE","EXECUTE","YES","NO"

"PUBLIC","SDE","ST_GEOMFROMTEXT","SDE","EXECUTE","YES","NO"

"PUBLIC","SDE","ST_GEOMFROMWKB","SDE","EXECUTE","YES","NO"

"PUBLIC","SDE","ST_GEOM_COLS_UTIL","SDE","EXECUTE","YES","NO"

"PUBLIC","SDE","ST_GEOM_UTIL","SDE","EXECUTE","YES","NO"

"PUBLIC","SDE","ST_INTERIORRINGN","SDE","EXECUTE","YES","NO"

"PUBLIC","SDE","ST_INTERSECTION","SDE","EXECUTE","YES","NO"

"PUBLIC","SDE","ST_INTERSECTS","SDE","EXECUTE","YES","NO"

"PUBLIC","SDE","ST_IS3D","SDE","EXECUTE","YES","NO"

"PUBLIC","SDE","ST_ISCLOSED","SDE","EXECUTE","YES","NO"

"PUBLIC","SDE","ST_ISEMPTY","SDE","EXECUTE","YES","NO"

"PUBLIC","SDE","ST_ISMEASURED","SDE","EXECUTE","YES","NO"

"PUBLIC","SDE","ST_ISRING","SDE","EXECUTE","YES","NO"

"PUBLIC","SDE","ST_ISSIMPLE","SDE","EXECUTE","YES","NO"

"PUBLIC","SDE","ST_LENGTH","SDE","EXECUTE","YES","NO"

"PUBLIC","SDE","ST_LINEFROMTEXT","SDE","EXECUTE","YES","NO"

"PUBLIC","SDE","ST_LINEFROMWKB","SDE","EXECUTE","YES","NO"

"PUBLIC","SDE","ST_LINESTRING","SDE","EXECUTE","YES","NO"

[VinceAngelo]

An attachment (.txt.zip) would have sufficed.  You have hundreds more objects than in my 10.1 geodatabase.  You'll probably need to talk to Tech Support to get this straight.

- V

[JonathanBailey]

Hi Vince,

I don't see a way to attach a file to a comment. Is there a way to do that?

Thanks,

Jon.

[VinceAngelo]

The "Advanced Editor" mode permits attachments.

[JonathanBailey]

Ah, I see. Thank you.

[JonathanBailey · Accepted solution]

It is the correct behaviour that the GFPTest user can't see the tables in SQL Developer, as the GFPTest user is not the owner of the tables.

In order to see the tables in SQL Developer, in the Connections window in SQL Developer, expand the database connection (connected as the GFPTest user), expand the Other Users folder, expand the SDE user node, and expand the Tables folder. The Tables folder will contain the tables owned by the SDE user.

Source: Esri Canada technical support