Re: PL/SQL Procedures & Roles
From: Willaim M Ryan <wryan_at_ca.oracle.com>
Date: 1996/08/19
Message-ID: <321860B5.3467_at_ca.oracle.com>#1/1
Date: 1996/08/19
Message-ID: <321860B5.3467_at_ca.oracle.com>#1/1
Douglas Scott wrote:
>
> Does anyone know where I can get some PL/SQL procedures that will
> control access of an Oracle Form using Oracle Roles? Specifically, I
> want the ability to give the user of the Form all the rights he/she
> needs on the tables when the Form is started and remove those rights
> when the form is exited.
>
> Thanks
> Douglas Scott
Douglas,
Use the menu application to control access through roles. Just create the specific roles and assign them to the various users through the menu. You don't need to create PL/SQL procedures to do this task.
Regards,
Bill Ryan Received on Mon Aug 19 1996 - 00:00:00 CEST