Oracle LBAC_EXP
Version 18.3

General Information
Library Note Morgan's Library Page Header
Which has the higher priority in your organization: Deploying a new database or securing the ones you already have? Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx.
Purpose Label Security export utility
AUTHID DEFINER
Dependencies
DBMS_ASSERT LBAC_CACHE LBAC_SERVICES
DBMS_PRIV_CAPTURE    
Documented No
First Available 12.2
Security Model Owned by SYS with EXECUTE granted to PUBLIC
Source {ORACLE_HOME}/rdbms/admin/prvtolsdd.plb
Subprograms
INSTANCE_INFO_EXP SCHEMA_INFO_EXP SYSTEM_INFO_EXP
 
INSTANCE_INFO_EXP
Label Security instance export for internal use only lbac_exp.instance_info_exp(
name      IN  VARCHAR2,
schema    IN  VARCHAR2,
prepost   IN  BINARY_INTEGER,
isdba     IN  BINARY_INTEGER,
version   IN  VARCHAR2,
new_block OUT BINARY_INTEGER)
RETURN VARCHAR2;
DECLARE
 nb_out BINARY_INTEGER;
 retVal VARCHAR2(60);
BEGIN
  retVal := lbac_exp.instance_info_exp('orabase2', 'C##SEC_ADMIN', 0, 1, '12.02.00', nb_out);
  dbms_output.put_line(TO_CHAR(nb_out));
  dbms_output.put_line(retVal);
END;
/
 
SCHEMA_INFO_EXP
Label Security schema export for internal use only lbac_exp.schema_info_exp(
schema    IN  VARCHAR2,
prepost   IN  BINARY_INTEGER,
isdba     IN  BINARY_INTEGER,
version   IN  VARCHAR2,
new_block OUT BINARY_INTEGER)
RETURN VARCHAR2;
DECLARE
 nb_out BINARY_INTEGER;
 retVal VARCHAR2(60);
BEGIN
  retVal := lbac_exp.schema_info_exp('SCOTT', 0, 1, '12.02.00', nb_out);
  dbms_output.put_line(TO_CHAR(nb_out));
  dbms_output.put_line(retVal);
END;
/
 
SYSTEM_INFO_EXP
Label Security system export for internal use only lbac_exp.system_info_exp(
prepost       IN  BINARY_INTEGER,
connectstring OUT VARCHAR2,
version       IN  VARCHAR2,
new_block     OUT BINARY_INTEGER)
RETURN VARCHAR2;
DECLARE
 cs_out VARCHAR2(60);
 nb_out BINARY_INTEGER;
 retVal VARCHAR2(60);
BEGIN
  retVal := lbac_exp.system_info_exp(0, cs_out, '12.02.00', nb_out);
  dbms_output.put_line(cs_out);
  dbms_output.put_line(TO_CHAR(nb_out));
  dbms_output.put_line(retVal);
END;
/

Related Topics
Built-in Functions
Built-in Packages
DBMS_MACOLS_SESSION
LBAC_SESSION
LBAC_STANDARD
OLS$DATAPUMP
OLS_DIP_NTFY
OLS_ENFORCEMENT
OLS_UTIL_WRAPPER
What's New In 18c
What's New In 19c

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2019 Daniel A. Morgan All Rights Reserved
  DBSecWorx