TCS Mass Permissions Edit

[Patrick Sparkman]

Is there a way, possibly via SQL to add a group to any video based on it's current permissions restricted to users/groups only (ie: not public)?  We have hundreds of videos that we'd like to add a new user group to their permissions, but want to keep from having to edit each video individually.

[ahmashar]

Hi Patrick,

did you really mean TCS or you meant TMS? it sounds like the heading should have been TMS Mass permissions Edit.

with correct heading you get more and accurate response. if you meant TCS, please ignore this message.

//Ahmad

[Patrick Sparkman]

Nope, heading is correct, TCS - Content Server.

[ahmashar]

ok, I read it a couple of times to get my mind around the issue

are you using 5.x version?

you can create a filtered imported users from AD and set the persmission for those videos based on that filtered list.

[Patrick Sparkman]

It's a bit more complex than that, we have 1000 or so videos already recorded, with permissions applied, and are looking to adjust the permissions to those videos.  We need to add one or two groups to each of those restricted videos, and need an easy way to do it in mass, instead of having to touch each and every single video to grant the additional permissions.

[kedang · Accepted solution]

Hi Patrick,

As you may already know, there's no existing capability on the TCS to do mass permission edit currently. You can inquire with your account team about putting in a feature request for this if it's a crucial feature for you and your organization.

You would need a SQL update or create query to do this as a bulk job.

Since I am not very fluent at writing SQL queries and scripts, I'll give you a general idea of what needs to be modified within the SQL database to achieve what you are looking for and maybe you can follow up with your own DBA to formulate the query.

This will make extensive modification to the accesslist table, so to protect your existing data, I recommend you take a SQL backup of the tcsdbv3 database before attempting to run any query. My interpretation of what needs to be modified may not be supported by the BU, so please proceed with this in mind that this is at your own risk. If you want to be absolutely sure, please create a TAC case and have the TAC engineer make the inquiry with the BU.

---

You can look in dbo.UserProfile to find the userId and roleId values to use to modify dbo.Accesslist rows or create new rows (for additional groups or users in accesslist for the same recording).

dbo.Conference - For particular conferences or all conferences,  denoted by conferenceID. Need guessAccess column to be false to modify  authenticated groups and users access list. If guest access is true,  accesslist cannot be modified.

You can also use this table to find metadata regarding particular conferences such as title if you need to modify specific recordings and not all.

dbo.AccessList - You need to modify userID here along with roleID for particular conferences or all conferences .  If there are multiple groups or users in access list, new row with same  conferenceID and additional userID / roleID needs to be created.

---

I hope this helped,

[Magnus Ohm · Accepted solution]

Hi Patrick

Kenneth has mentioned the tables of intrest here. Indeed this is very challenging but I created a simple query that can set a new group to have access to all the recordings. It depends on what kind of permissions you want to set. Editor or Viewer. But the real challenge would be to isolate the number of recordings to assign the new groups to i.e if it is 200 of 1000 recordings, how to best isolate these recordings? The restricted recordings are of course in the dbo.AccessList so if you have a spesific group that is not assigned to any other recordings than the ones that should be updated, it might be possible to get a pretty decent narrowed down list of recordings to update and take it from there.

But if you want to assign the new group to all your recordings, it is doable with a simple query. I tested it and it works but I don't think that is what you are looking for though.

/Magnus

[Patrick Sparkman]

It could work, most if not all but maybe 5% of our recordings that do contain permissions all have a select few groups in all of them.  This group we would be adding would be added to all restricted recordings except those 5%, which we could go back in afterward and remove as they are just a small amount in this very large amount of videos.

[Magnus Ohm]

Patrick check your PM. I have given you some instructions there. Hopefully that will help you. Of course it's on your own risk so backup!

/Magnus