Ektron – Remove Content/Folder Permissions

Posted on By David Kittell

Use EXTREME caution on this query.

I recommend you do a backup of your database before you run this script as this will remove all permissions that someone has setup on Ektron.

TRUNCATE TABLE [permissions_tbl];

UPDATE [content]
SET [inherit_permissions] = 0
	,[inherit_permissions_from] = 0
	,[private] = 0;
Originally Posted on August 20, 2014
Last Updated on October 26, 2015
All information on this site is shared with the intention to help. Before any source code or program is ran on a production (non-development) system it is suggested you test it and fully understand what it is doing not just what it appears it is doing. I accept no responsibility for any damage you may do with this code.
Code Ektron MSSQL - Ektron 8.0.2

Related Posts

Ektron List All PageBuilder Pages

Posted on

SET NOCOUNT ON DECLARE @Domain VARCHAR(50) SET @Domain = ‘/’ SELECT c.[content_id], c.[content_title], c.[content_html], CASE WHEN c.[content_status] = ‘A’ THEN ‘Approved’ WHEN c.[content_status] = ‘O’ THEN ‘Checked Out’ WHEN c.[content_status] = ‘I’ THEN ‘Checked In’ WHEN c.[content_status] = ‘S’ THEN ‘Submitted for Approval’ WHEN c.[content_status] = ‘M’ THEN ‘Marked for…

Read More

Remotely Find Raspberry Pi IP

Posted on

First install nmap sudo apt-get install nmap Then run IP addr show and look for something like ‘inet 10.1.1.68/24 brd 10.1.1.255’ ip addr show eth0 Now based on the inet IP CIDR type sudo nmap -sn 10.1.1.68/24 You should see something like this Nmap scan report for 10.1.1.54 Host is…

Read More