I am involved in a database migration project for an application to move from Oracle 7.3.4 to Oracle 9i. The application runs on HP-UX and uses Oracle Forms 4.5 as the front end. Currently there are separate user IDs for individual users on the database. One of the requirements for the migration is to finally have just one ID on the database side, and multiple users will be mapped to a single database user ID.
What I want to know is:
- Is there a way to map Unix user IDs to a single database ID?
- Since forms are tightly coupled to the database, is there a way of reading Unix environment variables into Forms?
This was first published in October 2004