507
Hi guys,
I blocked some fields from some tables to avoid some users accessing these fields.
However, it is quite unstable. After we restore model stone from Test to Production environment, it seems that the field is unblocked, which meant that the user can access these fields now.
BOD asked me for reason and what is the best procedure to avoid these issues happen again.
Could you please advise me?
Many thanks
Kylie
The issue has been resolved. I used the table level mehtod of setLogOnInfo()
Now my code is;
Share
Report
All responses (
Answers (
public void run()
{
Com comapp;
Com reporting;
Com IDatabase;
Com IDatabaseTable;
Com IDatabaseSingleTable;
COMVariant variant;
str paramwhole;
str paramfilename;
str paramCond;
str ViewYesNo;
int ret;
str selectionFormula;
int tC;
int i;
;
super();
breakpoint;
variant = new COMvariant(COMVariantInOut::OUT,COMVariantType::VT_BOOL) ;
comapp = new COM("CrystalRuntime.Application.11");
//comapp.LogonServer("crdb_odbc.dll","tms","tacs", "sa", "Hubleather123");
//paramwhole = this.args().parm("'{Employee.empcode}'='11752'");
paramwhole = this.args().parm();
//paramwhole = this.args().parm("{Employee.empcode}='11752'");
//paramwhole = this.args().parm("{?DateFrom}='01/01/2021';{?DateTo}='03/03/2021';{Employee.empcode}='11752'");
ret = strfind(paramwhole,"|",2,strlen(paramwhole));
paramfilename = "e:\\Report10.rpt"; //substr(paramwhole,2,ret-2) ;
paramcond = substr(paramwhole,ret 1,strlen(paramwhole));
ViewYesNo = substr(paramwhole,1,1);
reporting = comapp.openreport(paramfilename);
reporting.discardsaveddata();
reporting.RecordSelectionFormula(paramCond);
IDatabase =reporting.Database();
IDatabaseTable = IDatabase.Tables();
tC = IDatabaseTable.Count();
for (i = 1; i <= tC; i )
{
IDatabaseSingleTable = IDatabaseTable.Item(i);
IDatabaseSingleTable.SetLogOnInfo("tms","tacs","sa","Hubleather123");
IDatabaseSingleTable.TestConnectivity();
}
reporting.readrecords();
if(ViewYesNo == 'N')
{
variant.boolean(false);
reporting.PrintOut(variant);
}
else
{
ActiveX.ReportSource(reporting);
ActiveX.width(600);
ActiveX.height(350);
ActiveX.DisplayToolbar(true);
ActiveX.DisplayGroupTree(false);
ActiveX.ViewReport();
ActiveX.Refresh();
}
}
Hi Andre,
I agree with you. I did the override permission on Dev then redo on Production. Some override permission I did on Production only and we got some issues when restore model stone from Test to Production.
Many thanks for your advice.
Appreciated.
Ett
Hi Kylie,
If you do override of permissions in a production environment, it will make changes in the AOT. This is stored in the model store. Now, you moved the TEST model store to promote new customizations to the production which will overwrite the AOT changes done by the override of permissions. So, your process is causing the issue.
The best is to treat security permission changes as customizations in AX2012. Start in a DEV or TEST environment and then move it to the production environment via the model store or other deployment option.
Hi Kylie,
What are your steps? Have any errors or exceptions occurred？
To move user-to-role mapping information, you need to use Microsoft Dynamics AX data import/export to migrate the UserInfo and SecurityUserRole tables from the business database.
#1
André Arnaud de Cal...
293,274
Super User 2025 Season 1
#2
Martin Dráb
231,947
Most Valuable Professional
#3
nmaenpaa
101,156
Moderator
