Is there a way to dynamically create a library access list like there is for email distribution?

We have a report that will be bursted by territory or region. we would like to use Report Library to ensure only the appropriate people view only their territory information.

The challenge is sometime region names change and territory assignments can change.

any information on how to control access dynamically would be appreciated.

We are using WF 7.1.6

Hi JWalk,

Unfortunately, currently there isn’t a way to do this. The following document may be of interest:

Can access lists be created dynamically for Report Library?

To submit a New Feature Request (NFR), you may contact Information Builders' Customer Support Services and open a case for that. The phone number is 1-800-736-6130, or you may access InfoResponse.

Hope this help.

Cheers,

Kerry

Hi JWalk,

Though this is not supported by IBI Tech Support. We have done this at our site by writing MODIFY (Match/Merge) routines to update BOTLIST, BOTUPROF, WF_MRUSERS and WF_USRGRPTB tables. We are using Realm Driver for UAS. Hope this will give you a direction.

Here is an example of define to match with the tables.
DEFINE FILE ALIST
ACCESSNAME/A64='REGION ACCESS LIST';
COUNTER/A6='p'|| EMPID;
MEMBERTYPE/A1='U';
MEMBER/A6='p'|| EMPID;
INDEXVALUE/A6='p'|| EMPID;
USERID/A6=MEMBER ;
LOGINNAME/A6=MEMBER ;
DESCRIPTION/A41=FULLNAME;
USERNAME/A41=FULLNAME;
PASSWORD/A1='';
EMAIL/A22=EDIT(MEMBER,'999999') || '@NASGMT.COM';
ROLEID/A4='User';
PROPERTIES/A14='active,library';
GROUPID/A11='LibraryOnly';
ISACTIVE/A1='Y';
ISGRPADMIN/A1='N';
END