Re: FGAC-

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