Re: Replace an User function with Sql Statement

From: Sybrand Bakker <sybrandb_at_hccnet.nl>
Date: Wed, 01 Dec 2004 18:32:17 +0100
Message-ID: <stvrq0tc8r6j0sdtmr8088a4tefpk6bvvf@4ax.com>

On Tue, 30 Nov 2004 16:28:55 -0500, "Sam Palanivel" <sam_at_yorcomp.com> wrote:

>I have the following Sql which uses a function (check_user_priv) . How do I
>replace the function with ordinary Sql Statement? Thanks Sam

Apparently you want to merge the function in the statement. It is functionally completely unclear what the statement does, and you don't post the code of the function, so no one can really take up the task.
Apart from that, you might want to ask why you don't you Record Level Security aka Fine Grained Access Control

--
Sybrand Bakker, Senior Oracle DBA

Received on Wed Dec 01 2004 - 11:32:17 CST