Re: Controlling use of forms
From: Steve Cosner <stevec_at_zimmer.csufresno.edu>
Date: 1997/06/16
Message-ID: <866471202.10989_at_dejanews.com>#1/1
Date: 1997/06/16
Message-ID: <866471202.10989_at_dejanews.com>#1/1
In article <339D6BD6.5326_at_ite.his.se>,
Anders Gustavson <anders_at_ite.his.se> wrote:
>Does anyone know if it is possibel to restrict the usage of Oracle Forms
>via roles, ie I just want user that are members of an certain roles to
>be able to use a restricted form.
Yes. Check out table User_Role_Privs and the DBMS_SESSION.SET_ROLE package procedure. Your form can query User_Role_Privs to see if your user is granted the role required, and proceed or fail depending on the results.
Steve Cosner
-------------------==== Posted via Deja News ====----------------------- http://www.dejanews.com/ Search, Read, Post to UsenetReceived on Mon Jun 16 1997 - 00:00:00 CEST