topic Privileges for Oracle users created using Create Database User tool in Geodatabase Questions

Privileges for Oracle users created using Create Database User tool

JonathanBailey — Tue, 17 Mar 2015 08:46:56 GMT

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.

Re: Privileges for Oracle users created using Create Database User tool

George_Thompson — Tue, 17 Mar 2015 12:08:52 GMT

Hi Jon,

When you use that tool it creates a user that can own data in the geodatabase. Unless the GFPTest user has an data owned there will be nothing to display in SQLPlus.

Create a new feature class (just a empty, dummy one) on ArcCatalog as that GFPTest user then look in SQLPlus, does that user now have tables listed?

-George

Re: Privileges for Oracle users created using Create Database User tool

JonathanBailey — Tue, 17 Mar 2015 12:19:07 GMT

Hi George,

Thanks for your response.

Yes, if I create a new table in ArcCatalog using the GFPTest user, I can see it in SQL Developer.

How can I configure the user so that I can see the rest of the contents in the database (especially the SDE and GDB schema tables)?

Thanks,

Jon.

Re: Privileges for Oracle users created using Create Database User tool

George_Thompson — Tue, 17 Mar 2015 12:26:35 GMT

You would need to grant permissions of select on those specific tables to the user. I would not recommend this as modification of these table can cause geodatabase issues (and is unsupported).

Why does that data owner need access to those tables?

-George

Re: Privileges for Oracle users created using Create Database User tool

JonathanBailey — Tue, 17 Mar 2015 13:18:19 GMT

Hi George,

I'm trying to create a new geodatabase user -- so that user would need to be able to read the SDE and GDB system tables, wouldn't they?

Thanks,

Jon.

Re: Privileges for Oracle users created using Create Database User tool

VinceAngelo — Tue, 17 Mar 2015 13:37:53 GMT

Public access is granted to the SDE-owned tables by default. Unless you've got some automated process that's revoked the PUBLIC grant, you have access to the tables (in fact, connecting as the user to the geodatabase proves you do have access). ArcCatalog is not going to show any of the geodatabase implemntation tables owned by SDE (SDE.LAYERS,....), since they are "hidden" as part of the registry.

I think all you need to do is start using the geodatabase (though you should probably create new tablespaces for new data, and change the users' default tablespace to one of these, and configure DBTUNE first).

- V

Re: Privileges for Oracle users created using Create Database User tool

JonathanBailey — Tue, 17 Mar 2015 13:49:24 GMT

Hi Vince,

Understood that I shouldn't be able to see the system tables in ArcCatalog -- but it seems that the GFPTest user can't access these tables at all.

This issue arose because I was trying to connect to the geodatabase using a third-party tool, and received an error indicating that the GDB_ITEMS table couldn't be found -- which is what led me to connect with SQL Developer to see what could be accessed.

Thanks,

Jon.

Edit: See reply at bottom for an explanation of why the third-party tool was generating an error.

Re: Privileges for Oracle users created using Create Database User tool

VinceAngelo — Tue, 17 Mar 2015 13:56:47 GMT

Again, this is set up by default, by Create/Enable Enterprise Geodatabase (Data Management). It doesn't prevent someone from removing the PUBLIC grant, though. If the PUBLIC grant is removed (by misguided security types, for example), it needs to be replaced by a GDBUSER_ROLE, and SELECT grants to that role to each table from which PUBLIC access was revoked, then grants to DGBUSER_ROLE would need to be added for each new user.

- V

BTW: You need to go back and edit your GSE post, to include this information.

Re: Privileges for Oracle users created using Create Database User tool

JonathanBailey — Tue, 17 Mar 2015 14:01:36 GMT

Hi Vince,

I'll check with our DBA to see if anything like that has been done. I still don't understand, however, why the user seems to have access through ArcCatalog but not through other clients like SQL Developer.

Thanks,

Jon.

Re: Privileges for Oracle users created using Create Database User tool

JonathanBailey — Tue, 17 Mar 2015 15:45:02 GMT

Following is what my DBA has reported. Does this make any sense?

select * from dba_tab_privs where grantee='PUBLIC' and owner='SDE'
order by table_name;

You’ll see the GDB_ITEMS there.

This could suggest that synonyms are missing. The query doesn’t specifically refer to SDE.GDB_ITEMS.

Is there a missing step to create those synonyms? There’s an easy way to do it:

Thanks,

Jon.

Re: Privileges for Oracle users created using Create Database User tool

VinceAngelo — Tue, 17 Mar 2015 15:48:59 GMT

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

Re: Privileges for Oracle users created using Create Database User tool

JonathanBailey — Tue, 17 Mar 2015 16:08:53 GMT

"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"

Re: Privileges for Oracle users created using Create Database User tool

JonathanBailey — Tue, 17 Mar 2015 16:09:40 GMT

"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"

Re: Privileges for Oracle users created using Create Database User tool

JonathanBailey — Tue, 17 Mar 2015 16:12:44 GMT

"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"

Re: Privileges for Oracle users created using Create Database User tool

JonathanBailey — Tue, 17 Mar 2015 16:12:58 GMT

"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"

Re: Privileges for Oracle users created using Create Database User tool

VinceAngelo — Tue, 17 Mar 2015 16:22:42 GMT

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

Re: Privileges for Oracle users created using Create Database User tool

JonathanBailey — Tue, 17 Mar 2015 16:26:24 GMT

Hi Vince,

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

Thanks,

Jon.

Re: Privileges for Oracle users created using Create Database User tool

VinceAngelo — Tue, 17 Mar 2015 17:00:06 GMT

The "Advanced Editor" mode permits attachments.

Re: Privileges for Oracle users created using Create Database User tool

JonathanBailey — Tue, 17 Mar 2015 17:12:44 GMT

Ah, I see. Thank you.

Re: Privileges for Oracle users created using Create Database User tool

JonathanBailey — Thu, 19 Mar 2015 11:25:37 GMT

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