Policy - function_schema is not exp/imp properly [message #438800] |
Tue, 12 January 2010 05:40 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
dyahav
Messages: 32 Registered: March 2009
|
Member |
|
|
Hi,
I have a schema that contains a policy as follows:
BEGIN
SYS.DBMS_RLS.ADD_POLICY (
object_schema => 'DYAHAV'
,object_name => 'TBL_BASE'
,policy_name => MY_VPD_PREDICATE'
,function_schema =>NULL
,policy_function => 'MY_VPD_PREDICATE'
,statement_types => 'SELECT,INSERT,UPDATE,DELETE'
,policy_type => dbms_rls.dynamic
,long_predicate => FALSE
,update_check => FALSE
,static_policy => FALSE
,enable => TRUE );
END;
After export and import to other schema, the object_schema is updated correctly
but the function_schema is still DYAHAV.
I really don't know if it's a feature or a bug...
How can I avoid it?
Thanks
dyahav
|
|
|
|
Re: Policy - function_schema is not exp/imp properly [message #438804 is a reply to message #438802] |
Tue, 12 January 2010 05:59 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
dyahav
Messages: 32 Registered: March 2009
|
Member |
|
|
Thanks for the quick response.
The policy is defined for a specific schema such that the
function_schema => 'DYAHAV'
I would expect that value of 'function_schema' in the new schema will be the new schema name (the schema in which the import applied).
Furthermore, I would expect that Oracle will change the value of
'function_schema' if it changes the 'object_schema' properly.
Am I still mistake?
Thanks
dyahav
|
|
|
|
|
|
Re: Policy - function_schema is not exp/imp properly [message #438828 is a reply to message #438812] |
Tue, 12 January 2010 08:02 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
JRowbottom
Messages: 5933 Registered: June 2006 Location: Sunny North Yorkshire, ho...
|
Senior Member |
|
|
I had a similar problem exporting function based indexes, and re-importing them into a different schema.
The function based index was exported including the schema that owned the function, and when you imported it into a different schema, the function owning schema wasn't changed.
|
|
|