4 Replies Latest reply: May 23, 2011 5:59 AM by Mark Moran RSS

Group Segregation

Mark Moran

Hi guys,

We have a group\team here that deal with the public and some of the incidents they use may have sensitive peronal infomration in them. Is there a way to segregate all the incidents that come into this team's Q from the rest of the organistaion so that only them and the syatem administrators groups can see their incidnets? I have read about segregation at the Database level but is there another way to do this? Perhaps through group administration?




  • 1. Re: Group Segregation
    Sridhar Sadhasivam

    Having segregation at the DB level is the most effective one for SDE. In case you want to do that on the application side, you can have separate incident types created and associate a custom form to the same. You can use this custom incident type/form to log tickets having sensitive data. These incidents will not be available on the ‘normal’ popup and only on the custom incident form popup.


    Hope this will help you.





  • 2. Re: Group Segregation
    Mark Moran

    Hi Sridhar,

    Many thanks for that. I will most likely go down th DB route as it seems to be pretty well documented in the Database Admin Guide.




  • 3. Re: Group Segregation
    Jos Vervoorn

    Please be aware that data segregation (Group Segregation) is only valid on the SDE (View) level. Any other reporting solutions other than Crystal Reports from within SDE is not affected by this data type of segregation. So if you query the database directly on the tables of the SMDBA (based) views sensitive data is not protected.


    With kind regards,


    Jos Vervoorn

    Principal Consultant


    Description: C:\Users\jvervoor\AppData\Roaming\Microsoft\Signatures\Unit4_logo_BS_Mail.jpg


    UNIT4 N.V.

    The Netherlands

    Stationspark 1000, 3364 DA Sliedrecht, The Netherlands

    T +31 (0)184 44 44 44 **873 | F +31 (0)184 44 44 45| M +1 (0)6 3882178

    E Jos.Vervoorn@unit4.com<mailto:Jos.Vervoorn@unit4.com> | I www.unit4.nl<http://www.unit4.nl/>




    This message and any attachment(s) are intended only for the use of the named recipient and may contain information that is privileged, confidential or otherwise exempt from disclosure under applicable law. If you are not the intended recipient, please notify the sender by return e-mail and delete this message from your system. Do not disclose the contents of this document to any other persons. Violation of this notice may be unlawful. Please note that internet communications are not secure and e-mails are susceptible to change.

    Thank you for your cooperation.

  • 4. Re: Group Segregation
    Mark Moran

    Cheers for that Jos!