
February 12th, 2003, 02:34 PM
|
|
|
|
Join Date: Apr 2007
Location: OVERLAND PARK, Kansas, United States
Posts: 3
Time spent in forums: 36 sec
Reputation Power: 0
|
|
|
Require a Password for a table change
Any help here would be apprechiated.
I have an Oracle db used with a front end user interface. the GUI has provisions for creating employee records. The record contains the user's security permissions. So, a clerk that maintains changes for personal data like home phone number or address changes also has access to changing the employee's security settings. So, need an Oracle script that will require a psaaword before changing a table of security settings.
A message box requiring a password should popup anytime a user attempts to change the contents of a table (insert, update, delete). If correct password is entered, allow the change, otherwise, prevent any changes.
thanks for any help,
|