ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling
complimentary technical Workshops on Database Security for the first 30
Oracle Database customers located anywhere in North America, EMEA, LATAM, or
APAC that send an email to
asra_us@oracle.com. Request a Workshop for
your organization today.
Purpose
Label Security Utilities for Logical Standby Databases
AUTHID
DEFINER
Dependencies
CONFIGURE_OLS
OLS$COMPARTMENTS
OLS$USER_GROUPS
LBAC$SA_LABELS
OLS$GROUPS
OLS$USER_LEVELS
LBAC$USER_LIBT
OLS$LAB
OLS_ENFORCEMENT
LBAC_CACHE
OLS$LAB_LIBT
PLITBLM
LBAC_SERVICES
OLS$PROFILE
SA_SESSION
LBAC_STANDARD
OLS$USER
SA_SYSDBA
LBAC_SYSDBA
OLS$USER_COMPARTMENTS
SA_USER_ADMIN_INT
Documented
No
First Available
12.2
Security Model
Owned by LBACSYS with no privileges granted
Direct access to some objects in this package is prevented by means of an Accessible By clause.
lbac_lgstndby_util.add_compartments(
polid IN BINARY_INTEGER,
cuname IN VARCHAR2,
comps IN VARCHAR2,
access_mode IN VARCHAR2,
in_def IN VARCHAR2,
in_row IN VARCHAR2);
lbac_lgstndby_util.add_groups(
polid IN BINARY_INTEGER,
cuname IN VARCHAR2,
groups IN VARCHAR2,
access_mode IN VARCHAR2,
in_def IN VARCHAR2,
in_row IN VARCHAR2);
lbac_lgstndby_util.alter_compartments(
polid IN BINARY_INTEGER,
cuname IN VARCHAR2,
comps IN VARCHAR2,
access_mode IN VARCHAR2,
in_def IN VARCHAR2,
in_row IN VARCHAR2);
lbac_lgstndby_util.alter_groups(
polid IN BINARY_INTEGER,
cuname IN VARCHAR2,
groups IN VARCHAR2,
access_mode IN VARCHAR2,
in_def IN VARCHAR2,
in_row IN VARCHAR2);
lbac_lgstndby_util.configure_ols(userid IN BINARY_INTEGER);
conn lbacsys
Enter password:
Connected.
exec lbac_lgstndby_util.configure_ols(111);
BEGIN lbac_lgstndby_util.configure_ols(111); END;
*
ERROR at line 1:
ORA-06550: line 1, column 7:
PLS-00904: insufficient privilege to access object LBAC_LGSTNDBY_UTIL
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
lbac_lgstndby_util.convert_user_to_data_label(
pol_number IN BINARY_INTEGER,
num_label IN BINARY_INTEGER,
int_label IN VARCHAR2,
tag IN BINARY_INTEGER);
lbac_lgstndby_util.insert_label(
pol_number IN BINARY_INTEGER,
num_label IN BINARY_INTEGER,
str_label IN VARCHAR2,
int_label IN VARCHAR2,
flags IN BINARY_INTEGER);
lbac_lgstndby_util.set_compartments(
polid IN BINARY_INTEGER,
cuname IN VARCHAR2,
read_comps IN VARCHAR2,
write_comps IN VARCHAR2,
def_comps IN VARCHAR2,
row_comps IN VARCHAR2);
lbac_lgstndby_util.set_groups(
polid IN BINARY_INTEGER,
cuname IN VARCHAR2,
read_groups IN VARCHAR2,
write_groups IN VARCHAR2,
def_groups IN VARCHAR2,
row_groups IN VARCHAR2);
lbac_lgstndby_util.set_levels(
polid IN BINARY_INTEGER,
cuname IN VARCHAR2,
max_num IN BINARY_INTEGER,
min_num IN BINARY_INTEGER,
def_num IN BINARY_INTEGER,
row_num IN BINARY_INTEGER);
lbac_lgstndby_util.set_user_labels(
polid IN BINARY_INTEGER,
uname IN VARCHAR2,
max_read_label IN VARCHAR2,
max_write_label IN VARCHAR2,
min_lvl IN BINARY_INTEGER,
def_label IN VARCHAR2,
row_label IN VARCHAR2);
lbac_lgstndby_util.store_label_list(
policy_name IN VARCHAR2,
uname IN VARCHAR2,
max_read_label IN VARCHAR2,
max_write_label IN VARCHAR2,
min_write_label IN VARCHAR2,
read_label IN VARCHAR2,
write_label IN VARCHAR2,
row_label IN VARCHAR2,
privs IN BINARY_INTEGER,
stmt_type IN BINARY_INTEGER);