Geek Answers Handbook

What is the Oracle MLSLABEL data type?

I came across a strange data type in oracle called MLSLABEL. It is not specified in datatype docs and is valid only for the "trusted oracle" (whatever that is). The documentation I can find on it is this . What is MLSLABELand what does he do?

+5
source share
2 answers

MLSLABEL- is it (was it?) the data type used by Trusted Oracle, the predecessor of the Oracle Advanced Security Option. Admin docs say it has been included in regular Oracle for compatibility. Find out more .

Reliable Oracle as a brand has been replaced by ASO on Oracle 9i (I think). I do not think what is MLSLABELused in ASO (I can not find anything in the relevant documents). It is still supported in modern versions of the database. possible for backward compatibility:

SQL> select * from v$version;

BANNER
-----------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production
PL/SQL Release 11.1.0.6.0 - Production
CORE    11.1.0.6.0      Production
TNS for 32-bit Windows: Version 11.1.0.6.0 - Production
NLSRTL Version 11.1.0.6.0 - Production

SQL> create table mls (id number, lbl mlslabel);

Table created.

SQL>
+6
source

If I remember correctly, it is used for a finer resolution scheme. Oracle out of the box allows users to get permissions on views, tables, procs, etc. But if you need to restrict access to users based on the column value in the record, I think you can use shortcuts for this. On the other hand, I'm not sure when you go to virtual private databases (VPD), but this may not be what you are asking for.

0
source

More articles:


All Articles