Xref: alice comp.databases.oracle.tools:24323
Path: alice!news-feed.fnsi.net!netnews.com!feeder.qis.net!sunqbc.risq.qc.ca!carnaval.risq.qc.ca.POSTED!not-for-mail
Message-ID: <372F822A.62F89C18@musica.mcgill.ca>
From: Mike Rainville <ccre@musica.mcgill.ca>
Reply-To: Michel@cc.mcgill.ca
Organization: McGill University
X-Mailer: Mozilla 4.51 [en] (Win95; U)
X-Accept-Language: en,fr
MIME-Version: 1.0
Newsgroups: comp.databases.oracle.tools
Subject: Re: accessing the current user
References: <7gmu7q$704$1@nnrp1.dejanews.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Lines: 27
Date: Tue, 04 May 1999 23:28:09 GMT
X-Complaints-To: abuse@mcgill.ca
X-Trace: carnaval.risq.qc.ca 925860489 132.206.45.62 (Tue, 04 May 1999 19:28:09 EDT)
NNTP-Posting-Date: Tue, 04 May 1999 19:28:09 EDT

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@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