topic Re: Row level security ArcGIS 10.3 Desktop in ArcGIS Enterprise Questions

Row level security ArcGIS 10.3 Desktop

HiteshJilka — Wed, 18 May 2016 05:22:17 GMT

Hello,

In our geodatabase, one of our feature class has one column named STATUS which has values like Fixed, To Be Corrected, Pending..

We would like to implement row level security so that users don't modify the row that have value Fixed. From database end, I can define trigger but we also have delta table because of our feature class is registered as version. Hence defining triggers is not a good option.

Is there any solution in ArcGIS 10.3 desktop environment for implementing row level security ?

Thanks!

Re: Row level security ArcGIS 10.3 Desktop

PanagiotisPapadopoulos — Wed, 18 May 2016 07:29:18 GMT

row level security can be implemented at the RDBMS level.

for example Oracle use this https://www.oracle.com/database/label-security/index.html

for viewing purposes only you can create spatial views to restrict the viewing.

Re: Row level security ArcGIS 10.3 Desktop

HiteshJilka — Wed, 18 May 2016 08:14:50 GMT

Thanks for your suggestion, being an Oracle DBA I already came across virtual private database and label security features ...but as we are using geodatabase replica and all of our feature class are registered as version and so along with base table we have delta tables where new insert or update happens until geodatabase is compressed....Hence I asked this question to know if there is such type of security on ArcGIS ...

Re: Row level security ArcGIS 10.3 Desktop

PanagiotisPapadopoulos — Wed, 18 May 2016 10:57:16 GMT

Unfortunately no.

Arcgis does not support this.