How to set permissions at the level of fields?

Question

I�??m wondering if there is a way to grant permissions at level of field of particular attribute table.

For example, if an attribute table of a particular feature class has two fields F1 and F2 with two users u1 and u1 who have permissions to this particular feature. Then is there a way to limit the editing permission of u1 to F1 and u2 to F2 such that, for instance, u2 can�??t edit values of F1

Is that possible?

Thank you

Best

Jamal

JamalNUMAN · Answer

Yes, there is for example oracle have something called "Oracle Label Security" : http://www.oracle.com/us/products/database/options/label-security/overview/index.html

and sql server: http://sqlserverlst.codeplex.com/

what irritates me in this subject, is that "Geodatabases" should have been designed to be fully integrated with DBMS security 
solutions and implementations. Many big organizations are storing very highly sensitive data in production "GIS Databases" and as a consequence these GIS databases should be secure !!! there is a lot of amazing security techniques that would be great and "add value" if it were implemented on Geodatabase part in terms of security and this will definitely would make the ArcSDE Geodatabase product appealing to customers to implement in big GIS Enterprise landscape systems.

vote for my idea here: https://c.na9.visual.force.com/apex/ideaView?id=087E000000059iIIAQ

Thanks Emad for the help.

I have voted to the idea

Best

Jamal

EmadAl-Mousa · Answer

Yes, there is for example oracle have something called "Oracle Label Security" : http://www.oracle.com/us/products/database/options/label-security/overview/index.html

and sql server: http://sqlserverlst.codeplex.com/

what irritates me in this subject, is that "Geodatabases" should have been designed to be fully integrated with DBMS security 
solutions and implementations. Many big organizations are storing very highly sensitive data in production "GIS Databases" and as a consequence these GIS databases should be secure !!! there is a lot of amazing security techniques that would be great and "add value" if it were implemented on Geodatabase part in terms of security and this will definitely would make the ArcSDE Geodatabase product appealing to customers to implement in big GIS Enterprise landscape systems.

vote for my idea here: https://c.na9.visual.force.com/apex/ideaView?id=087E000000059iIIAQ

JamalNUMAN · Answer

This is not possible with any geodatabase tool.  The security model is only supported at 
table granularity.  If you use RDBMS tools to surpass this resolution, you risk undefined
geodatabase behavior.

- V

Thank you Vince for the help,

In general, is this possible in the non-spatial database like SQL server of Oracle?