This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

DEVELOPERS FORUM - Allow external DB Table (other than ITEMTYPE) in innovator

vishal_trivedi - Monday, January 3, 2011 4:26 PM:

Hi,

I am stuck somewhere and It's very urgent  for me please help me.

-- I have created an external table to retain some data.

-- I want to insert into that table from c# method of innovator. But it doesn't have permission on that table.

Please suggest me what to do???

It's really very urgent....

-- Vishal



Brian - Tuesday, January 4, 2011 5:31 AM:

Hi Vishal,

First you need to know who has access to the table. (Innovator Admin for example). I am assuming this is a table inside the Innovator Database.

Then you can "grantIdentity" to the method doing the work.

// Grant 'Aras PLM' permissionsa

Aras.Server.Security.Identity plmIdentity = Aras.Server.Security.Identity.GetByName("Aras PLM");

Boolean PermissionWasSet = Aras.Server.Security.Permissions.GrantIdentity(plmIdentity);

 

// do stuff here.

// revoke permissions at the end of the method.

    if (PermissionWasSet) Aras.Server.Security.Permissions.RevokeIdentity(plmIdentity);

Hope this helps.

Brian.