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
SQL Management Base Utilities
AUTHID
CURRENT_USER
Constants
SMB object type constants moved to DBMS_SMB_INTERNAL 2/28/07
Dependencies
DBMS_AUTO_INDEX
DBMS_SQLDIAG_INTERNAL
DBMS_STATS_INTERNAL
DBMS_PRIV_CAPTURE
DBMS_SQLQ
DBMS_SYS_ERROR
DBMS_SMB_INTERNAL
DBMS_SQLTCB_INTERNAL
PLITBLM
DBMS_SPD
DBMS_SQLTUNE
SQLSET_ROW
DBMS_SPM
DBMS_SQLTUNE_INTERNAL
SQL_PLAN_TABLE_TYPE
DBMS_SPM_INTERNAL
DBMS_SQLTUNE_UTIL0
WRI$_REPT_SPMEVOLVE
DBMS_SQLCONTROL_INTERNAL
DBMS_SQLTUNE_UTIL2
XMLTYPE
DBMS_SQLDIAG
DBMS_STANDARD
Documented
No
Exceptions
Error Code
Reason
ORA-19384
Cannot pack into staging table from previous version
ORA-19385
Staging table is empty
ORA-38171
Insufficient privileges for SQL management object operation
Raises an exception if the identified privilege is inadequate for SMB use
dbms_smb.check_smb_priv(priv_name IN VARCHAR2);
SQL> exec dbms_smb.check_smb_priv('DBA');
BEGIN dbms_smb.check_smb_priv('DBA'); END;
*
ERROR at line 1:
ORA-38171: Insufficient privileges for SQL management object operation
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 79
ORA-06512: at "SYS.DBMS_SMB", line 116
ORA-06512: at line 1
dbms_smb.open_stgtab_cursor(
qualified_stgtab_name IN VARCHAR2
sql_handle IN VARCHAR2,
obj_name IN VARCHAR2,
obj_type IN VARCHAR2,
sql_text IN CLOB,
creator IN VARCHAR2,
origin IN VARCHAR2,
enabled IN VARCHAR2,
accepted IN VARCHAR2,
fixed IN
VARCHAR2,
module IN VARCHAR2,
action IN VARCHAR2,
category IN VARCHAR2,
open_cur_flags IN BINARY_INTEGER,
stgtab_version IN NUMBER,
CUR OUT REF CURSOR);
dbms_smb.pack_stgtab(
staging_table_name IN VARCHAR2,
staging_table_owner IN VARCHAR2,
sql_handle IN VARCHAR2,
obj_name IN VARCHAR2,
obj_type IN VARCHAR2,
sql_text IN CLOB,
creator IN VARCHAR2,
origin IN VARCHAR2,
enabled IN VARCHAR2,
accepted IN VARCHAR2,
fixed IN VARCHAR2,
module IN VARCHAR2,
action IN VARCHAR2,
category IN VARCHAR2,
commit_rows IN NUMBER);
RETURN NUMBER;
dbms_smb.unpack_stgtab(
staging_table_name IN VARCHAR2,
staging_table_owner IN VARCHAR2,
sql_handle IN VARCHAR2,
obj_name IN VARCHAR2,
obj_type IN VARCHAR2,
sql_text IN CLOB,
creator IN VARCHAR2,
origin IN VARCHAR2,
enabled IN VARCHAR2,
accepted IN VARCHAR2,
fixed IN VARCHAR2,
module IN VARCHAR2,
action IN VARCHAR2,
category IN VARCHAR2,
replace IN BOOLEAN,
impcallout IN BOOLEAN)
RETURN NUMBER;