How to Enable/Disable the Oracle Lable Security:
SQL> select INSTANCE_NAME, HOST_NAME, STARTUP_TIME, STATUS, to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS') as current_date from gv$instance;
INSTANCE_NAME
----------------
HOST_NAME
----------------------------------------------------------------
STARTUP_TIME STATUS CURRENT_DATE
------------------ ------------ -----------------------------
PROD
hostname.domain.com
12-JAN-14 OPEN 29-JAN-2014 14:06:31
SQL> SELECT VALUE FROM V$OPTION WHERE PARAMETER = 'Oracle Label Security';
VALUE
----------------------------------------------------------------
FALSE
SQL> exit
[orprod@##### trace]$ chopt enable lbac
Writing to /u01/PROD/oracle/db/tech_st/11.2.0/db_1/install/enable_lbac.log...
/usr/bin/make -f /u01/PROD/oracle/db/tech_st/11.2.0/db_1/rdbms/lib/ins_rdbms.mk lbac_on ORACLE_HOME=/u01/PROD/oracle/db/tech_st/11.2.0/db_1
/usr/bin/make -f /u01/PROD/oracle/db/tech_st/11.2.0/db_1/rdbms/lib/ins_rdbms.mk ioracle ORACLE_HOME=/u01/PROD/oracle/db/tech_st/11.2.0/db_1
[orprod@##### trace]$ chopt disable lbac
Writing to /u01/PROD/oracle/db/tech_st/11.2.0/db_1/install/disable_lbac.log...
/usr/bin/make -f /u01/PROD/oracle/db/tech_st/11.2.0/db_1/rdbms/lib/ins_rdbms.mk lbac_on ORACLE_HOME=/u01/PROD/oracle/db/tech_st/11.2.0/db_1
/usr/bin/make -f /u01/PROD/oracle/db/tech_st/11.2.0/db_1/rdbms/lib/ins_rdbms.mk ioracle ORACLE_HOME=/u01/PROD/oracle/db/tech_st/11.2.0/db_1
[orprod@##### trace]$sqlplus "/as sysdba"
SQL*Plus: Release 11.2.0.3.0 Production on Wed Jan 29 14:15:25 2014
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, Oracle Label Security,
OLAP, Data Mining and Real Application Testing options
SQL> SELECT VALUE FROM V$OPTION WHERE PARAMETER = 'Oracle Label Security';
VALUE
----------------------------------------------------------------
TRUE
SQL>
No comments:
Post a Comment