Re: invoker rights

From: Murali <oraclems_at_hotmail.com>
Date: 6 Mar 2002 18:47:52 -0800
Message-ID: <22e6597b.0203061847.4202ca01@posting.google.com>

"John Dorlon" <john_at_ezsql.net> wrote in message news:<fXwh8.12855$L7.18519_at_rwcrnsc52.ops.asp.att.net>...
> Does anyone know where in the data dictionary invoker rights are stored?
> I want to be able to tell using some SYS-owned table or view if a certain
> object has been created with AUTHID CURRENT_USER or AUTHID DEFINER.
>
> Thanks,
>
> -John

Ha,

I had the same question sometime ago. SYS.PRECODURE$ will have a value of 17 for CURRENT_USER and 1 for DEFINER. Check out this Metalink thread for more details -

http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=FOR&p_id=181482.996

Murali
http://www.dbaquest.com/ Received on Wed Mar 06 2002 - 20:47:52 CST