Hi All,
I tried to configure user security for calling some menus and allow user only to access limited tables. After a while, I configured for GL | Reports | Reconciliation | Inventory Report. I open security type for 'Main Menu', then configure view access for that report.
The problem is, when I logged-in using the user with view access for that report, it showed:
Unable to run InventLedgerConciliation due to access restriction in table TmpInventBalance.
It seems that TmpInventBalance has 'InventTable' security key. But, when I try to open security setup for 'Security Key', I couldn't find Inventory management | Tables | 'Item posting' table (which is TmpInventBalance).
When I debug the code, at SysSecurity class of expandSecurityKey method, Line 123, the method will check if the table is allowed or not for security setup.
if (table.dataId == tableNum(TmpInventBalance)) //534
breakpoint;
dictTable = new SysDictTable(table.dataId);
breakpoint;
dictTable = new SysDictTable(table.dataId);
if (!dictTable.allowSecuritySetup())
continue;
continue;
At allowSecuritySetup method, it checks that if it is temporary table, then it won't shown.
boolean allowSecuritySetup()
{
if (this.isTmp() ||
this.isMap() ||
this.isView() ||
this.id() == tableNum(AccessRightslist) ||
this.id() == tableNum(SysConfig) ||
!this.securityKeyId() || //If not, the table rights cannot be calculated if the user is a member of >1 group
(this.configurationKeyId() && !isConfigurationkeyEnabled(this.configurationKeyId())))
return false;
return true;
}
{
if (this.isTmp() ||
this.isMap() ||
this.isView() ||
this.id() == tableNum(AccessRightslist) ||
this.id() == tableNum(SysConfig) ||
!this.securityKeyId() || //If not, the table rights cannot be calculated if the user is a member of >1 group
(this.configurationKeyId() && !isConfigurationkeyEnabled(this.configurationKeyId())))
return false;
return true;
}
So, what can I do to configure TmpInventBalance table security, then the user will be able to run the report ?
Many thanks,
Sonny Wibawa Adi
Do you Yahoo!?
Yahoo! Mail - Find what you need with new enhanced search. Learn more.
Sharing the knowledge on Axapta.
Yahoo! Groups Sponsor | |
|
|
Yahoo! Groups Links
- To visit your group on the web, go to:
http://groups.yahoo.com/group/Axapta-Knowledge-Village/
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.