Row level security ArcGIS 10.3 Desktop

Question

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!

PanagiotisPapadopoulos54 · Answer

Unfortunately no.

Arcgis does not support this.

HiteshJilka · Answer

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

PanagiotisPapadopoulos54 · Answer

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.