MS Access, VB, and Oracle Roles

[cornelli]

Is it possible to change the Oracle role of a using VB code, based on a particular data item? For example, if an insurance claim is open, Role A can read/update all the data. But when the claim is processed and closed, Role A should only be allowed to view the data. This needs to happen within the application, as soon as the code is flipped.

Any ideas?
Thanks!
kevin

 

[THoey]

Couldn't your Oracle DBA create an Update trigger that verifies whether or not the record is "OPEN" or "CLOSED" and just not allow an update if closed? Or, couldn't you do the same thing through VB code on your application side? Maybe I am confused... Terry
**************************
* General Disclaimor - Please read *
**************************
Please make sure your post is in the CORRECT forum, has a descriptive title, gives as much detail to the problem as possible, and has examples of expected results. This will enable me and others to help you faster...

 

[cornelli]

that is a possibility, but the problem is that there are multiple roles that need read access to the data...and one role needs to be able to update the *closed* indicator...which would then revert all the security for that record back to the previous, open version. i know this is confusing and complicated...and there may very well not be a viable solution....which means a re-design of the database....

thanks for your answer!!

kevin