Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have applied the section Access based on NTNAME in my application. When I am scheduling the application for reload using publisher and opening it throught access point it shows error mgs 'Failed to open Document,You dont have access to this Document'
But when I implement the Section Access without the Publisher its working fine .
I want to implement the section access based on NTNAME and reload the application using the Publisher.. Can any one guide me what more I have to consider in the section access to achive this .
Regards,
ELakkian.
hi Bill,
the fields for the service account is left blank . only the ACCESS, USERID is given except all are left blank only.
- Elakkian
Hi,
Can you post your section access script?
Bil
SECTION Access;
LOAD if(len(Access)=0,'ADMIN',Upper(Access)) as ACCESS,
UserID as NTNAME,
Upper(if(Len(trim([QCompany Code]))=0,'ALL',[QCompany Code])) as GROUP
FROM
[..\..\Data Sources\Access.xlsx]
Don't use ALL but * (Wildcard) for unfilled QCompyna Codes
The NTNAME field must also be stored as UPPER case in the section access table.
Keep in mind that the reduction field will be in upper case in the section access table, which means it also must be in upper case in the data model. The reduction is case sensitive.
Does your publisher task have a reduction? Or is only a plain reload?
Hi Elakkian,
Use the wildcard (*) character in your section access to grant full permission to yourself.
Please see attached excel file and use the script below...
star is *;
Section Access;
LOAD
Upper(Access)) as ACCESS,
UserID as NTNAME,
QCompany as GROUP
FROM
[..\..\Data Sources\Access.xlsx];
Section Application;
star is *;
Hi,
My suggestion would be start off simple and get it working. Then you can add all the additional stuff and if it doesn't work it is in you code.
Bill
HI Bill Britt,
Actually i did a sample with the same section access code and the excel file... its working perfectly, for other apps also its working but only for this app its not working ... i cant figure outs whats the problem which is violating the section access..
-Elakkian
There are three things that you can evaluate in order to resolve the issue. Please let us know if any of these resolve the issue.
1 All values in the Section Access table must be in UPPER case. Your NTNAMEs are not in upper case
2 If you use Strict Exclusion you can not use 'ALL' as wildcard value. Replace ALL with the star wildcard
3 The Star is * statement is generally not required in the script, so comment or delete them