Video Screencast Help
Symantec to Separate Into Two Focused, Industry-Leading Technology Companies. Learn more.

Export all Roles/Permissions settings

Created: 31 Oct 2012 | 6 comments

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!!!!!!!!

Comments 6 CommentsJump to latest comment

TeleFragger's picture

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..

Did we help you? Please Mark As Solution those posts which resolve your problem,

TeleFragger's picture

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

Did we help you? Please Mark As Solution those posts which resolve your problem,

Alex Bizjajev's picture

Hi TeleFragger,

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

Thank you,

Alex.

SaschaH's picture

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

Bechtle – your strong IT partner. Today and tomorrow

If that seems to help, please "Mark as Solution"

TeleFragger's picture

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..

AttachmentSize
Alt71_Priv_template.xlsx 32.54 KB

Did we help you? Please Mark As Solution those posts which resolve your problem,

Alex Bizjajev's picture

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.