Video Screencast Help
Search Video Help Close Back
to help

Export all Roles/Permissions settings

Created: 31 Oct 2012 | 6 comments
TeleFragger's picture
0 0 Votes
Login to vote

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

 

0
Login to vote
  • Actions
TeleFragger's picture

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

0
Login to vote
  • Actions
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.

0
Login to vote
  • Actions
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"

0
Login to vote
  • Actions
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
0
Login to vote
  • Actions
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.

0
Login to vote
  • Actions