knatunen@ujocs.joensuu.fi (Kari Natunen) (08/29/90)
UniFace is a application generator with 4 GL. It is mainly a tool for building forms which can use different kinds of databases. For instance ORACLE, INGRES and SYBASE/SQL Server are supported. Database handling is managed with drivers, one for each database. Drivers change the instructions from UniFace internal syntax to whatever DBMS understands. Relating to this there is a problem with user access rights: how to control. UniFace itself doesn't examine anything because all of the internal data handling is left for DBMS. There is some possible solutions to this: 1. DBMS does everything 2. Access rights are maintained with UniFace in it's database and everytime a table is accessed user rights are examined 3. ?? First two solutions aren't very good. In the second one programming would be difficult to do and the execution wouldn't be very fast. In the first one problems occur (depending on the DBMS to use) because access rights are different in the level of record. One can access for example account with number1-100000 and the other numbers 100000... What to do with this ? Please e-mail me if you know any used solutions relating to this either in the UniFace-environments or others. --------------------------------------------------------------- Kari Natunen mail: knatunen@ujocs.joensuu.fi University of Joensuu ---------------------------------------------------------------