Has anyone had success with the Table Data Authorizations (ttaad4134m000) session ?

Sometimes it works and sometimes it does not.

my tdsls045 table has no restrictions (not setup in the Maintain table authorizations by table)

at the Table Data Authorizations level I then permit open access (read/delete/modify/insert) only if the warehouse = 001.

But when using the display deliveries session the user can see deliveries from all warehouses....

any clues ?

Nick,

You need to verify the table authorizations as well as the session authorizations of the roles.

For some reason, it won't work that way (at least not in Baan4c4). What I have found is that you have to do the opposite and define what isn't authorized. Remove the current authorization and then add Not authorized if Not Equal to 001.

After delving a little deeper, I think the reason your original authorization didn't give the desired results is read/delete/modify/insert is granted by default (which is opposite of how session authorizations work).