Re: accessing the current user

Dear Dennis,

         I've been looking for exactly the same thing. So far, I've found the builtin DBMS_SESSION package for detecting ROLES and the database tables SESSION_ROLES and SESSION_PRIVS that can possibly (not tested yet) be used to detect the access rights of a user. (This is still Developer/2000 version 2.0)

Yours truly,
Mike Rainville

dhancock_at_voicenet.com wrote:

> in forms5.0 pl/sql is there a system variable that contains information about
> the current user (eg. user id)...or is the only way to use the sql 'select
> user from dual into v_user;'???
>
> i need a way to check the current users authority on a record.
>
> Also does anyone know of any good security resources/whitepapers/links with
> regards to the best way of securing a forms application??
>
> Thanks in advance,
> Dennis
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Wed May 05 1999 - 01:28:09 CEST