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

Regex Replace

Posted on

IF OBJECT_ID(N’dbo.RegexReplace’) IS NOT NULL DROP FUNCTION dbo.RegexReplace GO CREATE FUNCTION dbo.RegexReplace ( @pattern VARCHAR(255) ,@replacement VARCHAR(255) ,@Subject VARCHAR(MAX) ,@global BIT = 1 ,@Multiline BIT = 1 ) RETURNS VARCHAR(MAX) /*The RegexReplace function takes three string parameters. The pattern (the regular expression) the replacement expression, and the subject string to…

Read More

Trim Function

Posted on

–FOR SQL SERVER 2000: CREATE FUNCTION dbo.TRIM(@string VARCHAR(8000)) RETURNS VARCHAR(8000) BEGIN RETURN LTRIM(RTRIM(@string)) END GO –FOR SQL SERVER 2005: CREATE FUNCTION dbo.TRIM(@string VARCHAR(MAX)) RETURNS VARCHAR(MAX) BEGIN RETURN LTRIM(RTRIM(@string)) END GO Source: http://blog.sqlauthority.com/2007/04/24/sql-server-trim-function-udf-trim/ Originally Posted on August 8, 2013Last Updated on October 26, 2015 All information on this site is shared…

Read More