Re: accessing the current user

From: Mike Rainville <>
Date: Tue, 04 May 1999 23:28:09 GMT
Message-ID: <>

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 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 ==----------
> Search, Read, Discuss, or Start Your Own
Received on Wed May 05 1999 - 01:28:09 CEST

Original text of this message