How to set permissions at the level of fields?

1515
4
01-18-2014 10:29 AM
Highlighted
Honored Contributor
How to set permissions at the level of fields?

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
Reply
0 Kudos
4 Replies
Highlighted
Esri Esteemed Contributor
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
Reply
0 Kudos
Highlighted
Honored Contributor
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?
Reply
0 Kudos
Highlighted
Occasional Contributor III
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
Reply
0 Kudos
Highlighted
Honored Contributor
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
Reply
0 Kudos