General Information |
Library Note |
|
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 |
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('orabasex', 'C##SEC_ADMIN', 0, 1, '20.01.00', nb_out);
dbms_output.put_line(TO_CHAR(nb_out));
dbms_output.put_line(retVal);
END;
/
PL/SQL procedure successfully completed. |
|
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, '20.01.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, '20.01.00', nb_out);
dbms_output.put_line(cs_out);
dbms_output.put_line(TO_CHAR(nb_out));
dbms_output.put_line(retVal);
END;
/ |