|
Re: xml generate from db on redaction column [message #686560 is a reply to message #686559] |
Wed, 12 October 2022 04:16 |
John Watson
Messages: 8951 Registered: January 2010 Location: Global Village
|
Senior Member |
|
|
I get the same result as you, using release 19.3. I haven't tested on a later patchset or on 21.x, you can do that yourself. If it still doesn't work, then it may be a technology limitation, or perhaps they haven't got around to implementing it yet, or perhaps it is a bug.
In case anyone is interested, OP didn't provide a test case, but this is what I used:grant dba to scott;
conn scott/tiger
exec dbms_redact.add_policy(-
object_schema => 'scott',-
object_name => 'emp',-
column_name => 'ename',-
policy_name => 'redact ename', -
function_type => dbms_redact.full,-
expression =>'sys_context(''sys_session_roles'',''DBA'')= ''FALSE''');
select ename from emp;
SELECT XMLElement("emp", e.ename ) FROM emp e;
set role none;
select ename from emp;
SELECT XMLElement("emp", e.ename ) FROM emp e;
|
|
|
|