Re: Creating Tables

On Sun, 05 May 2002 13:19:14 GMT, marc_at_marcblum.de (Marc Blum) wrote:

>The problem:
>Everywhere in packages and triggers and SELECTs and bla ... we need to
>know the OS-user, which differs from the ORACLE-user. (In that
>context, it's not applicable to create an individual ORACLE-User for
>every person working with the application.)
>
>The solution:
>A packaged function, which returns the OS-User. The package is owned
>by SYS, the package gets GRANT EXECUTE TO PUBLIC and a PUBLIC SYNONYM.
>This one is the single only synonym in our whole application suite.
>
>The question:
>Am I evil? Do I have to go to church and pray to god to forgive me?
>Have I missed a new function in 8.x.x?

 sYS_CONTEXT('USERENV', 'OS_USER') ?

http://otn.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/a85397/function.htm#88362

-- 
Andy Hassall (andy@andyh.org) icq(5747695) http://www.andyh.org
http://www.andyh.uklinux.net/space | disk usage analysis tool