Question

Delete access right by process code

19:06 Jan 31, 2019

Hi all,

I'm trying to delete access rights by code in a process. I've tried the following, but it can find the table "SyAccountRight".

public virtual void DeleteAllRights(UserConnection uc, Guid recordId, string sSchemaName)
{
	string sRightSchemaName = "Sys" + sSchemaName + "Right";
	var esqRights = new EntitySchemaQuery(uc.EntitySchemaManager, sRightSchemaName);
	esqRights.Filters.Add(esqRights.CreateFilterWithParameters(FilterComparisonType.Equal, 
		"RecordId", recordId));
	var entities = esqRights.GetEntityCollection(uc);
	foreach(Entity entity in entities)
	{
		entity.Delete();
	}
}

Maybe with DBSecurityEngine, but I can't find any documentation on this class.

5 comments

Ryan Farley

19:55 Jan 31, 2019

I'm not sure you can use ESQ with Sys*Right tables (I don't see entity schemas for those) but I've never tried. It might work to use Delete, although I've not tried this on those tables either.

Something like this:

var del = new Delete(UserConnection)
    .From("SysAccountRight")
    .Where("RecordId").IsEqual(Column.Parameter(recordId)) as Delete;
del.Execute();

Ryan

Jerome BERGES

13:48 Feb 01, 2019

Thanks Ryan !

Anastasia Botezat

13:54 Feb 04, 2019

Dear Jerome,

In order to delete from rights table you can use the Delete class on the server side.

Firstly, you need to get the userConnection in order to pass it in the Delete query:

var userConnection = Get<UserConnection>("UserConnection");

After that you can create a delete query:

var delete = new Delete(userConnection)

.From("Order")

//add conditions

.Where("Opportunity").IsEqual(opportunityId)

.Where("Product").IsEqual(productId);

And execute it:

delete.execute();

Here is more info on the Delete class in the development manual:

https://academy.bpmonline.com/documents/technic-sdk/7-13/deleting-data-…

Regards,

Anastasia

Pavan Manne

16:11 May 15, 2023

Ryan Farley,

I have tried using delete . It is not deleting the record and no errors found.

Dmytro Vovchenko

17:56 May 24, 2023

Pavan Manne,

Hi,

You can find an example of how to edit access right via code inside the system in the schema ChangeAdminRightsUserTask.

In there you can find methods AddRecordRight/DeleteRecordRight, you need to realize something similar to them.

Show all comments