Help Tim!

All posts relating to Oracle PL/SQL development.

Moderator: Tim...

Help Tim!

Postby Guest » Mon Nov 01, 2004 6:09 pm

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
 

RE: Help Tim!

Postby Guest » Mon Nov 01, 2004 6:09 pm

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...
Guest
 


Return to Oracle SQL and PL/SQL Development

Who is online

Users browsing this forum: No registered users and 7 guests

cron