Hi,

We are using BaaNc4.

Need some help on table authorisation.

1. We have set table authorisation for table ticst001 for users that they cannot read/delete/insert/modify this table for certain order no and position no. it is working perfectly with all the session.

We have developed one print session using table ticst001 and we want users can print all the records using the customised session, but they are not able to do so , since users are not authorised to read the table.

Is there any way to make read permission localy in the session scripts, so that users can print all the records and after closing the session authorisation will be active again.

Regards,

Why do you secure your data from being read on screen, but then allow the same users to print the data?

Is it safer to have them read the information from paper than from a monitor?

I don't thinl what you are doing is possible using the standard Baan table authorisations since they work at the database driver level. The Baan session, be it print, maintain, or display is above this level and so has no influence of the data returned by data database driver.

Hi Tushar,

The suggestion i give is not the right way of getting things done..
but for academic purpose, the database authorisations are written in files found in $BSE/lib/user..the file will be named as p<user> or something like that (not sure)..i guess moving the file to another name will remove the auth...

but as i said, this is not the true soln to the problem...

database auth shud be avoided as much as possible, as the overhead is very high

Regards
venkat