Home » RDBMS Server » Security » DBMS_REDACT package not available in oracle 11g (11g, 11.2.0.1, windows 7)
DBMS_REDACT package not available in oracle 11g [message #597344] Thu, 03 October 2013 07:32 Go to next message
ishika_20
Messages: 334
Registered: December 2006
Location: delhi
Senior Member
Dear All,

we need to implement REDACT features in oracle 11g. Can you please guide me how to configure into it?

Below are my securities available in oracle 11g.

SQL> select parameter, value from v$option where upper(parameter) like '%SECURITY';

PARAMETER                                VALUE
---------------------------------------- ----------------------------------------
Enterprise User Security                 TRUE
Oracle Label Security                    TRUE



Regards,
Ishika

icon1.gif  Re: DBMS_REDACT package not available in oracle 11g [message #597345 is a reply to message #597344] Thu, 03 October 2013 08:01 Go to previous messageGo to next message
Michel Cadot
Messages: 58605
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Database Advanced Security Guide
Part II Using Oracle Data Redaction

Re: DBMS_REDACT package not available in oracle 11g [message #597346 is a reply to message #597344] Thu, 03 October 2013 08:04 Go to previous messageGo to next message
ishika_20
Messages: 334
Registered: December 2006
Location: delhi
Senior Member
Dear All,

Do I need to update patch on it to make it available??

Regards,
Ishika
icon13.gif  Re: DBMS_REDACT package not available in oracle 11g [message #597347 is a reply to message #597346] Thu, 03 October 2013 08:06 Go to previous messageGo to next message
Michel Cadot
Messages: 58605
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

You need to have 12c.

Re: DBMS_REDACT package not available in oracle 11g [message #597639 is a reply to message #597347] Mon, 07 October 2013 04:59 Go to previous message
Roachcoach
Messages: 1178
Registered: May 2010
Location: UK
Senior Member
It's back ported to 11.2.0.4 if I recall the version correctly.

http://docs.oracle.com/cd/E11882_01/appdev.112/e40758/d_redact.htm#CHDHEDAI
Previous Topic: GRANT ANY OBJECT PRIVILEGE
Next Topic: Oracle database vault query
Goto Forum:
  


Current Time: Mon Jul 28 22:35:19 CDT 2014

Total time taken to generate the page: 0.09922 seconds