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

Mac OSX Terminal – Xcode Reset

Posted on

Make sure Xcode is closed. defaults delete com.apple.dt.Xcode rm -rfv ~/Library/Application\ Support/Developer/Shared/Xcode rm -rfv ~/Library/Saved\ Application\ State/com.apple.dt.Xcode.savedState rm -rfv ~/Library/Preferences/com.apple.dt.Xcode.* rm -rfv ~/Library/Preferences/com.apple.dt.xcodebuild.plist rm -rfv ~/Library/MobileDevice/Provisioning\ Profiles/* Originally Posted on December 5, 2016Last Updated on December 13, 2016 All information on this site is shared with the intention to help….

Read More

Run SQL Statement

Posted on

protected string sRunSQLStmnt(string sSQL) { string sReturn = ""; //Declare the connection object SqlConnection sqlConn = new SqlConnection(connString); int numberOfRecords = 0; try { //Make the connection sqlConn.Open(); //Declare the Command SqlCommand sqlCommand = new SqlCommand(sSQL + " SELECT @@ROWCOUNT AS DELETED;", sqlConn); //Execute the query numberOfRecords = sqlCommand.ExecuteNonQuery(); }…

Read More