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 -> Re: FGAC-

Re: FGAC-

From: nasa <nasa.ora_at_gmail.com>
Date: 19 Sep 2006 01:27:15 -0700
Message-ID: <1158654435.228781.80070@d34g2000cwd.googlegroups.com>

hitman wrote:
> nasa wrote:
> > Thanks for continuing support.
> >
> > After reading thru various articles and tutorials of FGAC, I've started
> > to implement in my application.
> >
> > How FGAC works? My code not contains any sub-query select statements
> > but it still works fine, how?
> >
>
> When you use fine-grained access control, you create security policy
> functions
> attached to the table, view, or synonym on which you have based your
> application.
> Then, when a user enters a DML statement (SELECT, INSERT, UPDATE, or
> DELETE)
> on that object, Oracle dynamically modifies the user's
> statement-transparently to
> the user-so that the statement implements the correct access control.
>
> (Is this quote from App.Dev.Guide(9.2) page 12-40 satisfying for you?)

Hi,

After successfull creation of CREATE CONTEXT and Associate Package, my package has compilation error. The Details are:

--
1) CREATE OR REPLACE UserInfo USING user_roles_pkg;

2) CREATE OR REPLACE PACKAGE user_roles_pkg AS
3)  PROCEDURE setUser_type (strUserType IN CHAR);
4) END;
5) PROCEDURE setUser_type(strUserType IN CHAR) IS
6)  BEGIN
7)    DBMS_SESSION.SET_CONTEXT(UserInfo,'find_userType',strUserType);
8) END setUser_type;
9) END user_role_pkg;

The comiplation error on line 7 PLS-00201: identifier 'UserInfo' must
be declared.

The UserInfo is name of the context. Why the compiler treat as a
identifier?

Thanks

Rgds
Received on Tue Sep 19 2006 - 03:27:15 CDT

Original text of this message

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