Re: tough choices

From: Noons <wizofoz2k_at_yahoo.com.au.nospam>
Date: Sat, 26 Jun 2004 22:02:11 +1000
Message-ID: <40dd65ba$0$18190$afc38c87@news.optusnet.com.au>

Serge Rielau apparently said,on my timestamp of 26/06/2004 12:34 PM:

> ... WHERE has_privileges() = 1
>
> has_privileges() can be a UDF which dows whatever you please.
> Looking at any credentials the DBMS provides.

It's not a problem of credentials, Serge. I don't think has_privileges() can access the currently to-be-selected data and check it as if it was a normal predicate where clause.

Of course, it can check all sorts of other things. That is also available in any database that supports stored procedures/functions and their use in SQL, like Oracle and DB2 do.

-- 
Cheers
Nuno Souto
wizofoz2k_at_yahoo.com.au.nospam

Received on Sat Jun 26 2004 - 07:02:11 CDT