Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Fine grained access control - SYS user

Fine grained access control - SYS user

From: Thomas Hesse <thomas.hesse_at_team.xtra.co.nz>
Date: Tue, 23 Apr 2002 15:11:11 +1200
Message-ID: <3CC4D0CF.BA47305@team.xtra.co.nz>


Hi,

is it correct that the SYS user is not using any of the predicates ?

e.g. when I am using something like this:

CREATE OR REPLACE FUNCTION context_flag

                          (obj_schema VARCHAR2, obj_name VARCHAR2) 
                    RETURN VARCHAR2 IS d_predicate VARCHAR2(2000);

BEGIN
  d_predicate := 'flag = ''Y''';
  RETURN d_predicate;
END context_flag;

The users are only getting rows with flag='Y', but as SYS users I got all.

Is there a way to change this ?

Cheers
Thomas Received on Mon Apr 22 2002 - 22:11:11 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US