Where are the access rights stored for security roles in serialized files?











up vote
1
down vote

favorite
1












When we create security roles and assign access rights, corresponding serialized files for role get created. But when we look at the files we don't see any data related to access rights. So just wanted to know where the data related to access are stored.



We are using Unicorn for serialization.



Role: |
cheApprover
MemberOf:
Role: |
cheEditor









share|improve this question




















  • 1




    Access assignment is at the item level. When you serialize the home item, and if you changed security on it, then you should see what you expect.
    – Michael West
    Nov 26 at 11:55






  • 1




    For this, you can check the __Security Field, where rights are stored for an item. This is a shared field and as such will be in SharedFields table. Security information is actually a pipe delimited list.
    – Arvind Gehlot
    Nov 26 at 12:07








  • 1




    If you still don't find, please let me know, i may provide you the sql script to get that.
    – Arvind Gehlot
    Nov 26 at 12:14















up vote
1
down vote

favorite
1












When we create security roles and assign access rights, corresponding serialized files for role get created. But when we look at the files we don't see any data related to access rights. So just wanted to know where the data related to access are stored.



We are using Unicorn for serialization.



Role: |
cheApprover
MemberOf:
Role: |
cheEditor









share|improve this question




















  • 1




    Access assignment is at the item level. When you serialize the home item, and if you changed security on it, then you should see what you expect.
    – Michael West
    Nov 26 at 11:55






  • 1




    For this, you can check the __Security Field, where rights are stored for an item. This is a shared field and as such will be in SharedFields table. Security information is actually a pipe delimited list.
    – Arvind Gehlot
    Nov 26 at 12:07








  • 1




    If you still don't find, please let me know, i may provide you the sql script to get that.
    – Arvind Gehlot
    Nov 26 at 12:14













up vote
1
down vote

favorite
1









up vote
1
down vote

favorite
1






1





When we create security roles and assign access rights, corresponding serialized files for role get created. But when we look at the files we don't see any data related to access rights. So just wanted to know where the data related to access are stored.



We are using Unicorn for serialization.



Role: |
cheApprover
MemberOf:
Role: |
cheEditor









share|improve this question















When we create security roles and assign access rights, corresponding serialized files for role get created. But when we look at the files we don't see any data related to access rights. So just wanted to know where the data related to access are stored.



We are using Unicorn for serialization.



Role: |
cheApprover
MemberOf:
Role: |
cheEditor






security unicorn serialization






share|improve this question















share|improve this question













share|improve this question




share|improve this question








edited Nov 26 at 16:18









Dan Sinclair

1,137524




1,137524










asked Nov 26 at 11:32









Dheeraj p

17710




17710








  • 1




    Access assignment is at the item level. When you serialize the home item, and if you changed security on it, then you should see what you expect.
    – Michael West
    Nov 26 at 11:55






  • 1




    For this, you can check the __Security Field, where rights are stored for an item. This is a shared field and as such will be in SharedFields table. Security information is actually a pipe delimited list.
    – Arvind Gehlot
    Nov 26 at 12:07








  • 1




    If you still don't find, please let me know, i may provide you the sql script to get that.
    – Arvind Gehlot
    Nov 26 at 12:14














  • 1




    Access assignment is at the item level. When you serialize the home item, and if you changed security on it, then you should see what you expect.
    – Michael West
    Nov 26 at 11:55






  • 1




    For this, you can check the __Security Field, where rights are stored for an item. This is a shared field and as such will be in SharedFields table. Security information is actually a pipe delimited list.
    – Arvind Gehlot
    Nov 26 at 12:07








  • 1




    If you still don't find, please let me know, i may provide you the sql script to get that.
    – Arvind Gehlot
    Nov 26 at 12:14








1




1




Access assignment is at the item level. When you serialize the home item, and if you changed security on it, then you should see what you expect.
– Michael West
Nov 26 at 11:55




Access assignment is at the item level. When you serialize the home item, and if you changed security on it, then you should see what you expect.
– Michael West
Nov 26 at 11:55




1




1




For this, you can check the __Security Field, where rights are stored for an item. This is a shared field and as such will be in SharedFields table. Security information is actually a pipe delimited list.
– Arvind Gehlot
Nov 26 at 12:07






For this, you can check the __Security Field, where rights are stored for an item. This is a shared field and as such will be in SharedFields table. Security information is actually a pipe delimited list.
– Arvind Gehlot
Nov 26 at 12:07






1




1




If you still don't find, please let me know, i may provide you the sql script to get that.
– Arvind Gehlot
Nov 26 at 12:14




If you still don't find, please let me know, i may provide you the sql script to get that.
– Arvind Gehlot
Nov 26 at 12:14










2 Answers
2






active

oldest

votes

















up vote
3
down vote



accepted










Security stored on items



Access rights (security) are stored on the item itself, in the __Security field. You can see the contents of this field in a few ways:



Security Details tab



In the Content Editor, under the Security ribbon tab, click the Details button and you will see the following tab:



Security Details tab



Raw field values



If you want to be able to copy the security from one item to another (or manually manipulate the security settings [not recommended]), you can show standard fields (View ribbon tab -> Standard Fields) and show raw values (View ribbon tab -> Raw Values):



__Security raw values



Access Viewer



To see the effective security permissions for an item, you can use the Access Viewer (Security ribbon tab -> Access Viewer). This shows not just what security is set on the current item, but how the ancestors' security affects this item for a given user or role:



Access Viewer






share|improve this answer






























    up vote
    2
    down vote













    Security informations are stored on the item and stored in the __Security Field. This is a shared field and you should find it in SharedFields table.



    To get the value from database, you can trigger below SQL query



    SELECT  Id, ItemId, FieldId, Value, Created, Updated
    FROM SharedFields
    WHERE ItemId = '{A57C19C2-8EE3-4DEC-AA39-0B8D522D59EB}' AND FieldId = '{DEC8D2D5-E3CF-48B6-A653-8E69E2716641}' /* Guid is the ID of the __Security field */


    Result



    8AA77E96-2330-4BE1-A554-BAE9C60536FF    A57C19C2-8EE3-4DEC-AA39-0B8D522D59EB    DEC8D2D5-E3CF-48B6-A653-8E69E2716641    au|sitecoreagency|pd|-item:write|-item:admin|!*|+item:read|-item:delete|-item:create|-item:rename|pe|-item:write|-item:admin|!*|+item:read|-item:delete|-item:create|-item:rename| 2011-03-07 11:48:14.563 2011-03-07 11:48:14.563
    06A6DB6C-6DEF-40E0-8CF8-8E179877DBB8 A57C19C2-8EE3-4DEC-AA39-0B8D522D59EB DEC8D2D5-E3CF-48B6-A653-8E69E2716641 au|sitecoreagency|pd|-item:write|-item:admin|!*|+item:read|-item:delete|-item:create|-item:rename|pe|-item:write|-item:admin|!*|+item:read|-item:delete|-item:create|-item:rename| 2011-03-07 11:48:14.270 2011-03-07 11:48:14.270





    share|improve this answer





















      Your Answer








      StackExchange.ready(function() {
      var channelOptions = {
      tags: "".split(" "),
      id: "664"
      };
      initTagRenderer("".split(" "), "".split(" "), channelOptions);

      StackExchange.using("externalEditor", function() {
      // Have to fire editor after snippets, if snippets enabled
      if (StackExchange.settings.snippets.snippetsEnabled) {
      StackExchange.using("snippets", function() {
      createEditor();
      });
      }
      else {
      createEditor();
      }
      });

      function createEditor() {
      StackExchange.prepareEditor({
      heartbeatType: 'answer',
      convertImagesToLinks: false,
      noModals: true,
      showLowRepImageUploadWarning: true,
      reputationToPostImages: null,
      bindNavPrevention: true,
      postfix: "",
      imageUploader: {
      brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
      contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
      allowUrls: true
      },
      onDemand: true,
      discardSelector: ".discard-answer"
      ,immediatelyShowMarkdownHelp:true
      });


      }
      });














      draft saved

      draft discarded


















      StackExchange.ready(
      function () {
      StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsitecore.stackexchange.com%2fquestions%2f15158%2fwhere-are-the-access-rights-stored-for-security-roles-in-serialized-files%23new-answer', 'question_page');
      }
      );

      Post as a guest















      Required, but never shown

























      2 Answers
      2






      active

      oldest

      votes








      2 Answers
      2






      active

      oldest

      votes









      active

      oldest

      votes






      active

      oldest

      votes








      up vote
      3
      down vote



      accepted










      Security stored on items



      Access rights (security) are stored on the item itself, in the __Security field. You can see the contents of this field in a few ways:



      Security Details tab



      In the Content Editor, under the Security ribbon tab, click the Details button and you will see the following tab:



      Security Details tab



      Raw field values



      If you want to be able to copy the security from one item to another (or manually manipulate the security settings [not recommended]), you can show standard fields (View ribbon tab -> Standard Fields) and show raw values (View ribbon tab -> Raw Values):



      __Security raw values



      Access Viewer



      To see the effective security permissions for an item, you can use the Access Viewer (Security ribbon tab -> Access Viewer). This shows not just what security is set on the current item, but how the ancestors' security affects this item for a given user or role:



      Access Viewer






      share|improve this answer



























        up vote
        3
        down vote



        accepted










        Security stored on items



        Access rights (security) are stored on the item itself, in the __Security field. You can see the contents of this field in a few ways:



        Security Details tab



        In the Content Editor, under the Security ribbon tab, click the Details button and you will see the following tab:



        Security Details tab



        Raw field values



        If you want to be able to copy the security from one item to another (or manually manipulate the security settings [not recommended]), you can show standard fields (View ribbon tab -> Standard Fields) and show raw values (View ribbon tab -> Raw Values):



        __Security raw values



        Access Viewer



        To see the effective security permissions for an item, you can use the Access Viewer (Security ribbon tab -> Access Viewer). This shows not just what security is set on the current item, but how the ancestors' security affects this item for a given user or role:



        Access Viewer






        share|improve this answer

























          up vote
          3
          down vote



          accepted







          up vote
          3
          down vote



          accepted






          Security stored on items



          Access rights (security) are stored on the item itself, in the __Security field. You can see the contents of this field in a few ways:



          Security Details tab



          In the Content Editor, under the Security ribbon tab, click the Details button and you will see the following tab:



          Security Details tab



          Raw field values



          If you want to be able to copy the security from one item to another (or manually manipulate the security settings [not recommended]), you can show standard fields (View ribbon tab -> Standard Fields) and show raw values (View ribbon tab -> Raw Values):



          __Security raw values



          Access Viewer



          To see the effective security permissions for an item, you can use the Access Viewer (Security ribbon tab -> Access Viewer). This shows not just what security is set on the current item, but how the ancestors' security affects this item for a given user or role:



          Access Viewer






          share|improve this answer














          Security stored on items



          Access rights (security) are stored on the item itself, in the __Security field. You can see the contents of this field in a few ways:



          Security Details tab



          In the Content Editor, under the Security ribbon tab, click the Details button and you will see the following tab:



          Security Details tab



          Raw field values



          If you want to be able to copy the security from one item to another (or manually manipulate the security settings [not recommended]), you can show standard fields (View ribbon tab -> Standard Fields) and show raw values (View ribbon tab -> Raw Values):



          __Security raw values



          Access Viewer



          To see the effective security permissions for an item, you can use the Access Viewer (Security ribbon tab -> Access Viewer). This shows not just what security is set on the current item, but how the ancestors' security affects this item for a given user or role:



          Access Viewer







          share|improve this answer














          share|improve this answer



          share|improve this answer








          edited Nov 26 at 14:12









          jrap

          2,3851625




          2,3851625










          answered Nov 26 at 12:26









          Dan Sinclair

          1,137524




          1,137524






















              up vote
              2
              down vote













              Security informations are stored on the item and stored in the __Security Field. This is a shared field and you should find it in SharedFields table.



              To get the value from database, you can trigger below SQL query



              SELECT  Id, ItemId, FieldId, Value, Created, Updated
              FROM SharedFields
              WHERE ItemId = '{A57C19C2-8EE3-4DEC-AA39-0B8D522D59EB}' AND FieldId = '{DEC8D2D5-E3CF-48B6-A653-8E69E2716641}' /* Guid is the ID of the __Security field */


              Result



              8AA77E96-2330-4BE1-A554-BAE9C60536FF    A57C19C2-8EE3-4DEC-AA39-0B8D522D59EB    DEC8D2D5-E3CF-48B6-A653-8E69E2716641    au|sitecoreagency|pd|-item:write|-item:admin|!*|+item:read|-item:delete|-item:create|-item:rename|pe|-item:write|-item:admin|!*|+item:read|-item:delete|-item:create|-item:rename| 2011-03-07 11:48:14.563 2011-03-07 11:48:14.563
              06A6DB6C-6DEF-40E0-8CF8-8E179877DBB8 A57C19C2-8EE3-4DEC-AA39-0B8D522D59EB DEC8D2D5-E3CF-48B6-A653-8E69E2716641 au|sitecoreagency|pd|-item:write|-item:admin|!*|+item:read|-item:delete|-item:create|-item:rename|pe|-item:write|-item:admin|!*|+item:read|-item:delete|-item:create|-item:rename| 2011-03-07 11:48:14.270 2011-03-07 11:48:14.270





              share|improve this answer

























                up vote
                2
                down vote













                Security informations are stored on the item and stored in the __Security Field. This is a shared field and you should find it in SharedFields table.



                To get the value from database, you can trigger below SQL query



                SELECT  Id, ItemId, FieldId, Value, Created, Updated
                FROM SharedFields
                WHERE ItemId = '{A57C19C2-8EE3-4DEC-AA39-0B8D522D59EB}' AND FieldId = '{DEC8D2D5-E3CF-48B6-A653-8E69E2716641}' /* Guid is the ID of the __Security field */


                Result



                8AA77E96-2330-4BE1-A554-BAE9C60536FF    A57C19C2-8EE3-4DEC-AA39-0B8D522D59EB    DEC8D2D5-E3CF-48B6-A653-8E69E2716641    au|sitecoreagency|pd|-item:write|-item:admin|!*|+item:read|-item:delete|-item:create|-item:rename|pe|-item:write|-item:admin|!*|+item:read|-item:delete|-item:create|-item:rename| 2011-03-07 11:48:14.563 2011-03-07 11:48:14.563
                06A6DB6C-6DEF-40E0-8CF8-8E179877DBB8 A57C19C2-8EE3-4DEC-AA39-0B8D522D59EB DEC8D2D5-E3CF-48B6-A653-8E69E2716641 au|sitecoreagency|pd|-item:write|-item:admin|!*|+item:read|-item:delete|-item:create|-item:rename|pe|-item:write|-item:admin|!*|+item:read|-item:delete|-item:create|-item:rename| 2011-03-07 11:48:14.270 2011-03-07 11:48:14.270





                share|improve this answer























                  up vote
                  2
                  down vote










                  up vote
                  2
                  down vote









                  Security informations are stored on the item and stored in the __Security Field. This is a shared field and you should find it in SharedFields table.



                  To get the value from database, you can trigger below SQL query



                  SELECT  Id, ItemId, FieldId, Value, Created, Updated
                  FROM SharedFields
                  WHERE ItemId = '{A57C19C2-8EE3-4DEC-AA39-0B8D522D59EB}' AND FieldId = '{DEC8D2D5-E3CF-48B6-A653-8E69E2716641}' /* Guid is the ID of the __Security field */


                  Result



                  8AA77E96-2330-4BE1-A554-BAE9C60536FF    A57C19C2-8EE3-4DEC-AA39-0B8D522D59EB    DEC8D2D5-E3CF-48B6-A653-8E69E2716641    au|sitecoreagency|pd|-item:write|-item:admin|!*|+item:read|-item:delete|-item:create|-item:rename|pe|-item:write|-item:admin|!*|+item:read|-item:delete|-item:create|-item:rename| 2011-03-07 11:48:14.563 2011-03-07 11:48:14.563
                  06A6DB6C-6DEF-40E0-8CF8-8E179877DBB8 A57C19C2-8EE3-4DEC-AA39-0B8D522D59EB DEC8D2D5-E3CF-48B6-A653-8E69E2716641 au|sitecoreagency|pd|-item:write|-item:admin|!*|+item:read|-item:delete|-item:create|-item:rename|pe|-item:write|-item:admin|!*|+item:read|-item:delete|-item:create|-item:rename| 2011-03-07 11:48:14.270 2011-03-07 11:48:14.270





                  share|improve this answer












                  Security informations are stored on the item and stored in the __Security Field. This is a shared field and you should find it in SharedFields table.



                  To get the value from database, you can trigger below SQL query



                  SELECT  Id, ItemId, FieldId, Value, Created, Updated
                  FROM SharedFields
                  WHERE ItemId = '{A57C19C2-8EE3-4DEC-AA39-0B8D522D59EB}' AND FieldId = '{DEC8D2D5-E3CF-48B6-A653-8E69E2716641}' /* Guid is the ID of the __Security field */


                  Result



                  8AA77E96-2330-4BE1-A554-BAE9C60536FF    A57C19C2-8EE3-4DEC-AA39-0B8D522D59EB    DEC8D2D5-E3CF-48B6-A653-8E69E2716641    au|sitecoreagency|pd|-item:write|-item:admin|!*|+item:read|-item:delete|-item:create|-item:rename|pe|-item:write|-item:admin|!*|+item:read|-item:delete|-item:create|-item:rename| 2011-03-07 11:48:14.563 2011-03-07 11:48:14.563
                  06A6DB6C-6DEF-40E0-8CF8-8E179877DBB8 A57C19C2-8EE3-4DEC-AA39-0B8D522D59EB DEC8D2D5-E3CF-48B6-A653-8E69E2716641 au|sitecoreagency|pd|-item:write|-item:admin|!*|+item:read|-item:delete|-item:create|-item:rename|pe|-item:write|-item:admin|!*|+item:read|-item:delete|-item:create|-item:rename| 2011-03-07 11:48:14.270 2011-03-07 11:48:14.270






                  share|improve this answer












                  share|improve this answer



                  share|improve this answer










                  answered Nov 26 at 12:49









                  Arvind Gehlot

                  1,152425




                  1,152425






























                      draft saved

                      draft discarded




















































                      Thanks for contributing an answer to Sitecore Stack Exchange!


                      • Please be sure to answer the question. Provide details and share your research!

                      But avoid



                      • Asking for help, clarification, or responding to other answers.

                      • Making statements based on opinion; back them up with references or personal experience.


                      To learn more, see our tips on writing great answers.





                      Some of your past answers have not been well-received, and you're in danger of being blocked from answering.


                      Please pay close attention to the following guidance:


                      • Please be sure to answer the question. Provide details and share your research!

                      But avoid



                      • Asking for help, clarification, or responding to other answers.

                      • Making statements based on opinion; back them up with references or personal experience.


                      To learn more, see our tips on writing great answers.




                      draft saved


                      draft discarded














                      StackExchange.ready(
                      function () {
                      StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsitecore.stackexchange.com%2fquestions%2f15158%2fwhere-are-the-access-rights-stored-for-security-roles-in-serialized-files%23new-answer', 'question_page');
                      }
                      );

                      Post as a guest















                      Required, but never shown





















































                      Required, but never shown














                      Required, but never shown












                      Required, but never shown







                      Required, but never shown

































                      Required, but never shown














                      Required, but never shown












                      Required, but never shown







                      Required, but never shown







                      Popular posts from this blog

                      mysqli_query(): Empty query in /home/lucindabrummitt/public_html/blog/wp-includes/wp-db.php on line 1924

                      How to change which sound is reproduced for terminal bell?

                      Can I use Tabulator js library in my java Spring + Thymeleaf project?