I am currently trying to add better security into my applications by using the username of the user with: -
OSuser()
I have created a very simple inline load with username and access which is then mapped on to the main table against OSuser(). I then use a 'Where' statement based on the access to either keep or drop the data.
ACCESS:
LOAD * INLINE
[
User, Access
USER\joe.bloggs, 1
];
accessmap:
MAPPING LOAD
User,
Access
RESIDENT ACCESS;
DROP TABLE ACCESS;
MAIN:
a,
b,
c,
OSUSER() as User
MAIN2:
a as a1,
b,
c,
User
RESIDENT MIAN
WHERE applymap('accessmap', User) = 1;
DROP TABLE MAIN;
The only problem with this is that the application needs to reload automatically each time it is opened......is this possible? and if so how can you do it?
Failing that is there a better way to add security based upon OSuser()??
If you are using OSUser() you must use the NTNAME instead. Besides, you will need to add the ACCESS field, with values of ADMIN or USER depending on the account. Check this thread among others on how to build a section access using NTNAME.
.png "Miguel_Angel_Baeyens"){kind=avatar}
