topic Difference Between ArcGIS Pro and ArcCatalog, setting privileges in one vs the other in ArcGIS Pro Questions

Difference Between ArcGIS Pro and ArcCatalog, setting privileges in one vs the other

BenVan_Kesteren1 — Fri, 26 Jun 2020 05:53:22 GMT

Hey,

I used to create views in arcCatalog, then I would set the view to be publicly available to all members of our database.

Very simple process:

Now I have just created a view in ArcPro, I try to tell it that this view should be public as I had done in the past in Catalog, but this time I am not able to set anything:

I am wondering... is this step not required? Are all views available to all database members by default? If that is the case, I am guessing this must have been an unnecessary setting, available to me in ArcCatalog.

Can anyone confirm how this should work? Only one of the two screenshots above are correct, I am unsure which one.

Re: Difference Between ArcGIS Pro and ArcCatalog, setting privileges in one vs the other

Asrujit_SenGupta — Sun, 28 Jun 2020 09:29:48 GMT

Either the behavior has changed in ArcGIS Pro(which doesn't seem to be the case, as per Esri documentation) or ArcGIS Pro is incorrectly displaying the message (which seems to be the case).

ArcGIS Desktop: Views in an enterprise geodatabase—Geodatabases in Oracle | Documentation

ArcGIS Pro:Views in an enterprise geodatabase—ArcGIS Pro | Documentation

You can grant users select privileges to views in the same way as to tables. Therefore, you can use views to control access to rows or columns in tables.

I am wondering... is this step not required? Are all views available to all database members by default? If that is the case, I am guessing this must have been an unnecessary setting, available to me in ArcCatalog.

No, it is required. The Views are not available to all users by default.

Kory Kramer‌

Re: Difference Between ArcGIS Pro and ArcCatalog, setting privileges in one vs the other

BenVan_Kesteren1 — Mon, 29 Jun 2020 00:41:39 GMT

Thanks so much for your details, should I go through my local support (ESRI Australia) to log this? Would that be the best method?

Re: Difference Between ArcGIS Pro and ArcCatalog, setting privileges in one vs the other

BenVan_Kesteren1 — Mon, 29 Jun 2020 00:59:47 GMT

Just to clarify my situation it is a SQL server enterprise geodatabase. The same statement is visible on:

Views in an enterprise geodatabase—Manage geodatabases in SQL Server | Documentation

Cheers

Re: Difference Between ArcGIS Pro and ArcCatalog, setting privileges in one vs the other

Asrujit_SenGupta — Mon, 29 Jun 2020 05:32:54 GMT

I checked again and found this Bug: BUG-000115693: Unable to manage user privileges on database view in..

Tried the "Change Privileges" tool and it worked as suggested in the link. So try that for now, till ArcGIS Pro 2.6 is out.