Home » SQL & PL/SQL » Client Tools » [SQL*Plus] SET SECUREDCOL (11.2.* and 12.1.*)
[SQL*Plus] SET SECUREDCOL [message #645714] Sun, 13 December 2015 09:40 Go to next message
Michel Cadot
Messages: 65848
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

From SQL*Plus Reference:

Quote:
SET SECUREDCOL {OFF | ON} [UNAUTH[ORIZED] text] [UNK[NOWN] text]

Sets how secure column values are displayed in SQLPLUS output for users without permission to view a column and for columns with unknown security. You can choose either the default text or specify the text that is displayed. The default is OFF.
...


How to define a column as "secure" and how to define "permission"? What is a "column with unknown security"?
Chapter 9 "SQL*Plus Security" does not mention anything about this and I found nothing on the web.

Re: [SQL*Plus] SET SECUREDCOL [message #645715 is a reply to message #645714] Sun, 13 December 2015 09:48 Go to previous message
Michel Cadot
Messages: 65848
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

OK I found the answer: it is related to Real Application Security:
http://docs.oracle.com/database/121/RASAD/toc.htm
http://docs.oracle.com/database/121/DBFSG/toc.htm

[Updated on: Sun, 13 December 2015 09:49]

Report message to a moderator

Previous Topic: Could not resolve service name
Next Topic: Is there a difference between procedure successfully completed and anonymous block competed? (merged 3)
Goto Forum:
  


Current Time: Sat Oct 20 04:12:04 CDT 2018