Forum Discussion

nchagan's avatar
nchagan
Ideator I
5 years ago

ApplySQL Previleges Issue

Hello All, I have a method that uses ApplySQL which works just fine for the user that have administrative privileges. However, for non-admin users the method does not work and error out. Learned th...
miraks's avatar
miraks
Creator II
5 years ago

Hi,

If you need to use applySQL, you can do it on server side only like this:
var superidentity = Aras.Server.Security.Identity.GetByName("Administrators");
bool permissionWasSet = Aras.Server.Security.Permissions.GrantIdentity(superidentity);

var sql= "your sql order here";
var updateReturn = innovator.applySQL(sql);
if (permissionWasSet) {
Aras.Server.Security.Permissions.RevokeIdentity(superidentity);
}

If you need to do it in javascript, you will have to call the server method from the javascript.