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


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 Usenet
Received on Mon Jun 16 1997 - 00:00:00 CEST

Original text of this message