-
Creating Policy
Hi,
I want create policy like this but I getting error message please help anybody correct this one.
SA_SYSDBA.CREATE_POLICY(POLICY_NAME=>'SADM',
*
ERROR at line 2:
ORA-06550: line 2, column 1:
PLS-00201: identifier 'SA_SYSDBA.CREATE_POLICY' must be declared
ORA-06550: line 2, column 1:
PL/SQL: Statement ignored
SA_SYSDBA.CREATE_POLICY(POLICY_NAME=>'SADM',
*
ERROR at line 2:
ORA-06550: line 2, column 1:
PLS-00201: identifier 'SA_SYSDBA.CREATE_POLICY' must be declared
ORA-06550: line 2, column 1:
PL/SQL: Statement ignored
Advance Thanks.
-
I can't say for certain without seeing all of the sql. But it looks like you need a direct grant. Either an object grant or create policy grant, or both.
-
Hi,
Thank for Quick reply
Actually I am following this help file
http://www.dbasupport.com/oracle/ora9i/OLS2_2.shtml
line : "See Listing 2.1 for the script used to create the security policy".
because I want same functionality in my Data base so, first I can test above procedure then after I can do.
Could you please above check link.
Please help me ....
Advance Thanks.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|