Row level security ArcGIS 10.3 Desktop

4626
3
05-17-2016 10:22 PM
HiteshJilka
New Contributor III

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!

0 Kudos
3 Replies
PanagiotisPapadopoulos
Esri Regular Contributor

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.

HiteshJilka
New Contributor III

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

0 Kudos
PanagiotisPapadopoulos
Esri Regular Contributor

Unfortunately no.

Arcgis does not support this.

0 Kudos