Spectrum Spatial (SSA/LIM)

I have different users with different roles and they will be accessing the same table. I managed to give certain permissions to edit few columns in the table for one particular role. Here is the question, How do I give the permission to a different role with a different set of columns editing capabilities on the same table?

<?xml version="1.0" encoding="UTF-8"?>

<FeatureEditing>

<table>

<showAllAttributes>false</showAllAttributes>

<primaryKey>

<includeInInsert>false</includeInInsert>

<hidden>true</hidden>

<showDisabled>true</showDisabled>

</primaryKey>

<geometrySupported>

<line>false</line>

<point>false</point>

<polygon>false</polygon>

</geometrySupported>

<columns>

<column>

<dbColumnName>qc_status</dbColumnName>

<name>QC Status</name>

<required>true</required>

<defaultValue>Under Review</defaultValue>

<pickList>

<Option>Completed</Option>

<Option>Rejected</Option>

<Option>FS Validation</Option>

</pickList>

</column>

<column>

<dbColumnName>qc_comments</dbColumnName>

<name>QC Comments</name>

<required>true</required>

</column>

</columns>

</table>

</FeatureEditing>

The above XML code is just to give permission for one role. Is there any chance that we can include role wise editing ?

Hi Krishna

There are two issues here

• Granting edit rights to roles on tables
• Configuring which columns can be edited

You can grant edit rights in Spectrum management Console to different roles as described here http://support.pb.com/help/analyst/12.0/admin_guide/en/index.html#appendix/appendixE.html

For example you can give edit rights on a table to both role1 and role2

We do not support column based permissions but you can achieve the desired behaviour as follows:-

The Edit Validation Template (the XML file) is used to manage what columns are presented to users when they have permissions to perform the editing. The way to give different columns to different users is to:-

·   Create two edit validation templates for the same table (each with different columns) let’s call them edittemplate1 and edittemplte2 and place them in the featureEditTemplates folder

·   Create two map configurations in SSA Admin Console (for example mapconfg1 and mapconfig2) for each case. Both would contain a layer with the table to be edited and editing would be enabled in the map configurations.

·   Then for mapconfig1 you would choose edittemplate1 to use for the table and for mapconfig1 you would choose edittemplate2. This is under the map configs -> template mappings tab.

·   Then under permissions -> map confg permisisons Role1 would be given permissions to access mapconfig1 and Role2 would be given permissions to access mapconfig2

This way

users in role1 would only be able to access mapconfig1 and to edit the columns specified in edittemplate1

users in role2 would only be able to access mapconfig2 and to edit the columns specified in edittemplate2

Thanks, Mr. Mustafa for the simpler solution.I have been trying to make this happen on single map configuration. Your approach looks simple and quite easy to configure, this is a great help.