topic Re: How to set permissions at the level of fields? in Data Management Questions

How to set permissions at the level of fields?

JamalNUMAN — Sat, 18 Jan 2014 18:29:46 GMT

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

Re: How to set permissions at the level of fields?

VinceAngelo — Sat, 18 Jan 2014 18:50:48 GMT

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

Re: How to set permissions at the level of fields?

JamalNUMAN — Fri, 24 Jan 2014 06:30:19 GMT

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?

Re: How to set permissions at the level of fields?

EmadAl-Mousa — Fri, 24 Jan 2014 06:57:56 GMT

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

Re: How to set permissions at the level of fields?

JamalNUMAN — Fri, 24 Jan 2014 16:37:35 GMT

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