Client Management Suite

 View Only
  • 1.  Export all Roles/Permissions settings

    Posted Oct 31, 2012 01:50 PM

    Ok so we have to do a UAR (User Access Review).

    I was not there when my group setup NS6 but they said they were able to export all permissions and roles based settings. We do this for security and what not.
    Anyone know how to export this in 7.1?

    mucho appreciate it as i would really not like to do this manually!!!!!!!!



  • 2.  RE: Export all Roles/Permissions settings

    Posted Oct 31, 2012 03:28 PM

    tried figuring out what i could tie together in SMP_7_1_database_schema.pdf

    but i dont know... im not that good at sql.. i can get by..

     



  • 3.  RE: Export all Roles/Permissions settings

    Posted Nov 01, 2012 05:57 AM

    guess i will be typing this all out by hand... yikes!



  • 4.  RE: Export all Roles/Permissions settings

    Broadcom Employee
    Posted Nov 01, 2012 07:55 AM

    Hi TeleFragger,

    May you clarify a bit - have you tried to export-import security settings using the "migration wizard" capabilities?

    Thank you,

    Alex.



  • 5.  RE: Export all Roles/Permissions settings

    Posted Nov 02, 2012 05:21 AM

    Permissions will be hard to do. For Roles and their Priviliges so you can use the SQL from this post

    http://www-secure.symantec.com/connect/forums/sql-query-security-role-membership#comment-4123601

     



  • 6.  RE: Export all Roles/Permissions settings

    Posted Nov 02, 2012 08:08 AM
      |   view attached

    i have not touched the migration wizard at all...

    scared too... so you can run the migration wizard and do portions?

     

    i manually typed it out yesterday...

    i have attached what I was trying to get... our custom roles removed of course..

     

    Attachment(s)

    xlsx
    Alt71_Priv_template_0.xlsx   32 KB 1 version


  • 7.  RE: Export all Roles/Permissions settings

    Broadcom Employee
    Posted Nov 02, 2012 10:02 AM

    Migration wizard has several importers that should be able to import the security settings. I think you may try to unselect everything but them, perform the database backup of 7.1 server and give a chance for migration wizard to import 6.x data.