Help Tim!

[Guest]

Tim,
I have the following code set up in Security_package body:

CREATE OR REPLACE PACKAGE BODY Security_Package IS
FUNCTION User_Data_Select_Security(Owner VARCHAR2, Objname VARCHAR2)RETURN VARCHAR2 IS
Predicate VARCHAR2(2000);
BEGIN
If ACCESS_RESTRICT = 1 then
Predicate := Null;
ELSEIF ACCESS_RESTRICT = 2 then
Predicate := ‘USER_ID = SYS_CONTEXT(“AP32ADMINâ€

[Guest]

You don't have to set the table name. When you apply the security policy you assign the packaged procedure to a specific table. This is how you 'specify' the table name, not in the security package itself.

Cheers

Tim...