Custom Permissions Levels - List out Permission Levels

Question

Hi all,

Is there an easy way to list out custom permission levels into a spreadsheet or something similar for comparrison purposes. We have a site with a sizable number of permission levels and its difficut to remember which levels assign which exact permissions.

I can't see that there's anything built in to do this but wondered if there's a 3rd party tool that can do this?

Thanks

Etala

Answer 1

I don't know if this is what you are looking for but here is a small sql query from my arsenal that lists out all the users together with the user groups for the site. You can always export the SQL output to excel (csv) format.

SELECT dbo.Groups.ID, dbo.Groups.Title, dbo.UserInfo.tp_Title, dbo.UserInfo.tp_Login FROM dbo.GroupMembership INNER JOIN dbo.Groups ON dbo.GroupMembership.SiteId = dbo.Groups.SiteId INNER JOIN dbo.UserInfo ON dbo.GroupMembership.MemberId = dbo.UserInfo.tp_ID

click on the top left cell in sql result window and save as csv. Now open this saved csv in excel

Answer 2

Hi,

I'd like to give this a go but can't seem to copy the SQL from the window. Can you copy it into the text window?

Which DB/Table would this be run against?

Thanks

Answer 3

You can highlight all the users and paste it in to an Excel sheet? Always works for me. the format may be a bit all over the place because of the presence but if you paste it into word first, it comes in as a table and then you can copy the columns that you need. Might be easier in the long run?

Answer 4

Hi SoapyJ

Not quite sure what you mean. I'd like to be able to copy out all the permissions that make up a permission level (i.e. Manage Lists, Override Check Out etc) and import this into a Spreadsheet so I can compare the various levels together.

As far as I know there's no easy way to do this from the Permission Level page? Or am I missing something?

Answer 5

one of the recommended way is to use PowerShell to query the data and export to Excel.

But select content directly from page in browser and copy&paste into excel is really a handy workaround.