Re: FGAC-

nasa wrote:
> 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

I've fixed the error.
Many Thanks!!! Received on Tue Sep 19 2006 - 05:39:10 CDT