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

    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

              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!