Ask the Expert

Mapping multiple users to a single database user ID

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:

  1. Is there a way to map Unix user IDs to a single database ID?
  2. Since forms are tightly coupled to the database, is there a way of reading Unix environment variables into Forms?

    Requires Free Membership to View

Many applications use a single Oracle user ID in the database for all connections to the database. Therefore, from the application side all users are connecting to an Oracle session using the same database username (schema). But, in order to achieve this, you have to create your own system_user table within the schema that will store the UNIX users' ID and password. You have to create your own log-on screen and handle security and encryption (there is built-in package to encrypt the data) yourself.

This was first published in October 2004

There are Comments. Add yours.

TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: