| General Information |
| Source |
Not found |
| Dependencies |
SELECT name FROM dba_dependencies WHERE referenced_name = 'MGMT_USER'
UNION
SELECT referenced_name FROM dba_dependencies WHERE name = 'MGMT_USER'; |
| Security Model |
Owned by SYSMAN with no granted privileges |
| |
| ADD_CALLBACK |
| Undocumented |
mgmt_user.add_callback(proc_in IN VARCHAR2, type_in IN NUMBER); |
| TBD |
| |
| CHECK_DROP_USER_CONFLICTS |
| Undocumented |
mgmt_user.check_drop_user_conflicts(user_name_in IN VARCHAR2)
RETURN sysman.mgmt_user_objects; |
DECLARE
muo sysman.mgmt_user_objects;
BEGIN
muo := mgmt_user.check_drop_user_conflicts('SYS');
END;
/ |
| |
| CHECK_REASSIGN_USER_CONFLICTS |
| Undocumented |
mgmt_user.check_reassign_user_conflicts(
user_name_in IN VARCHAR2,
new_user_name_in IN VARCHAR2)
RETURN sysman.mgmt_user_objects; |
DECLARE
muo sysman.mgmt_user_objects;
BEGIN
muo := mgmt_user.check_reassign_user_conflicts('UWCLASS', 'SYS');
END;
/ |
| |
| CHECK_USER_EXISTS |
| Raises "ORA-20204: User does not exist" if the user does not have EM management privs. |
mgmt_user.check_user_exists(user_name_in IN VARCHAR2); |
exec sysman.mgmt_user.check_user_exists('SYSMAN');
exec sysman.mgmt_user.check_user_exists('SCOTT'); |
| |
| CORRECTIVE_ACTION_DELETED |
| Undocumented |
mgmt_user.corrective_action_deleted(job_guid_in IN RAW); |
| TBD |
| |
| CREATE_PRIV |
| Undocumented |
mgmt_user.create_priv(
priv_name_in IN VARCHAR2,
priv_type_in IN VARCHAR2, -- a value between 1 and 6
description_in IN VARCHAR2); |
SELECT priv_name, priv_type
FROM sysman.mgmt_privs
ORDER BY 2,1;
exec mgmt_user.create_priv('TESTPRIV', 6, 'Test Description');
SELECT priv_name, priv_type
FROM sysman.mgmt_privs
ORDER BY 2,1;
exec mgmt_user.drop_priv('TESTPRIV');
SELECT priv_name, priv_type
FROM sysman.mgmt_privs
ORDER BY 2,1; |
| |
| CREATE_ROLE |
Undocumented
Overload 1 |
mgmt_user.create_role(role_name_in IN VARCHAR2, description_in IN VARCHAR2); |
col description format a40
SELECT * FROM sysman.mgmt_roles;
exec sysman.mgmt_user.create_role('TEST_ROLE', 'Test role description');
SELECT * FROM sysman.mgmt_roles;
exec sysman.mgmt_user.drop_role('TEST_ROLE');
SELECT * FROM sysman.mgmt_roles; |
| Overload 2 |
mgmt_user.create_role(
role_name_in IN VARCHAR2,
description_in IN VARCHAR2,
roles_in IN smp_emp_string_array,
privileges_in IN mgmt_user_privileges,
users_in IN smp_emp_string_array); |
| TBD |
| |
| CREATE_USER |
Undocumented
Overload 1 |
mgmt_user.create_user(
user_name_in IN VARCHAR2,
password_in IN VARCHAR2,
email_addresses_in IN smp_emp_string_array,
roles_in IN smp_emp_string_array,
privileges_in IN mgmt_user_privileges,
user_type_in IN NUMBER); |
| TBD |
| Overload 2 |
mgmt_user.create_user(
user_name_in IN VARCHAR2,
password_in IN VARCHAR2,
email_addresses_in IN VARCHAR2,
roles_in IN smp_emp_string_array,
privileges_in IN mgmt_user_privileges,
user_type_in IN NUMBER); |
| TBD |
| |
| CREATE_USER_DBCONSOLE |
| Undocumented |
mgmt_user.create_user_dbconsole(
user_name_in IN VARCHAR2,
password_in IN VARCHAR2,
email_addresses_in IN smp_emp_string_array,
roles_in IN smp_emp_string_array,
privileges_in IN mgmt_user_privileges); |
| TBD |
| |
| DROP_PRIV |
| Undocumented |
mgmt_user.drop_priv(priv_name_in IN VARCHAR2); |
| See CREATE_PRIV Demo Above |
| |
| DROP_ROLE |
| Undocumented |
mgmt_user.drop_role(role_name_in IN VARCHAR2); |
SQL> create role zzyzx;
Role created.
SQL> SELECT role
2 FROM dba_roles
3 WHERE role LIKE 'Z%';
SQL> /
ROLE
------------------------------
ZZYZX
SQL> exec mgmt_user.drop_role('ZZYZX');
BEGIN mgmt_user.drop_role('ZZYZX'); END;
*
ERROR at line 1:
ORA-20205: Role does not exist: ZZYZX
ORA-06512: at "SYSMAN.MGMT_USER", line 5647
ORA-06512: at line 1 |
| |
| DROP_USER |
| Undocumented |
mgmt_user.drop_user(user_name_in IN VARCHAR2, new_user_name_in IN VARCHAR2); |
| TBD |
| |
| DROP_USER_COMPLETE |
| Undocumented |
mgmt_user.drop_user_complete(user_name_in IN VARCHAR2, new_user_name_in IN VARCHAR2); |
| TBD |
| |
| EM4745545052454449434154454A |
| Undocumented |
mgmt_user.em4745545052454449434154454A(
p_schema IN VARCHAR2,
p_object IN VARCHAR2)
RETURN VARCHAR2; |
| TBD |
| |
| EM47455450524544494341544554 |
| Undocumented |
mgmt_user.em4745545052454449434154554(
p_schema IN VARCHAR2,
p_object IN VARCHAR2)
RETURN VARCHAR2; |
| TBD |
| |
| GET_ACCESS_INFO |
| Undocumented |
mgmt_user.get_access_info(
p_target_name IN VARCHAR2,
p_target_type IN VARCHAR2,
p_error_message OUT VARCHAR2,
p_super_or_owner OUT VARCHAR2,
p_user_name OUT sysman.VARCHAR2_TABLE,
p_user_description OUT sysman.VARCHAR2_TABLE,
p_user_privilege OUT sysman.VARCHAR2_TABLE); |
| TBD |
| |
| GET_ACCESS_INFO_TEMPLATE |
| Undocumented |
mgmt_user.get_access_info_template(
p_target_name IN VARCHAR2,
p_target_type IN VARCHAR2,
p_error_message OUT VARCHAR2,
p_super_or_owner OUT VARCHAR2,
p_user_name OUT sysman.varchar2_table,
p_user_description OUT sysman.varchar2_table,
p_user_privilege OUT sysman.varchar2_table); |
| TBD |
| |
| GET_CA_PREDICATE |
| Undocumented |
mgmt_user.get_ca_predicate(p_schema IN VARCHAR2, p_object IN VARCHAR2) RETURN VARCHAR2; |
| TBD |
| |
| GET_CURRENT_EM_USER |
| Undocumented |
mgmt_user.get_current_em_user RETURN VARCHAR2; |
| SELECT mgmt_user.get_current_em_user FROM dual; |
| |
| GET_MAX_PRIV |
Undocumented
Overload 1 |
mgmt_user.get_max_priv RETURN VARCHAR2; |
SELECT mgmt_user.get_max_priv
FROM dual; |
| Overload 2 |
mgmt_user.get_max_priv(user_name_in IN VARCHAR2) RETURN VARCHAR2; |
SELECT mgmt_user.get_max_priv('UWCLASS')
FROM dual; |
| |
| GET_METRIC_PREFS_ALIAS |
| Undocumented |
mgmt_user.get_metric_prefs_alias(user_name_in IN VARCHAR2, target_type_in IN VARCHAR2)
RETURN VARCHAR2; |
SELECT mgmt_user.get_metric_prefs_alias('UWCLASS', 'TABLE')
FROM dual; |
| |
| GET_MGMT_PRIVS |
| Undocumented |
mgmt_user.get_mgmt_privs(
super_user_out OUT NUMBER,
emrep_user_out OUT NUMBER,
emd_user_out OUT NUMBER,
valid_em_user_out OUT NUMBER); |
set serveroutput on
DECLARE
suo NUMBER;
emruo NUMBER;
emduo NUMBER;
veuo NUMBER;
BEGIN
mgmt_user.get_mgmt_privs(suo, emruo, emduo, veuo);
dbms_output.put_line(suo);
dbms_output.put_line(emruo);
dbms_output.put_line(emduo);
dbms_output.put_line(veuo);
END;
/ |
| |
| GET_NODE_LIST_WITH_PRIVILEGE |
| Undocumented |
mgmt_user.get_node_list_with_privilege(p_privilege IN VARCHAR2) RETURN REF CURSOR; |
| TBD |
| |
| GET_PRIVS |
| Undocumented |
mgmt_user.get_privs(
priv_type_in IN NUMBER,
user_defined_in IN NUMBER,
privs_out OUT sysman.smp_emd_string_array); |
desc sysman.mgmt_privs
SELECT priv_name, priv_type
FROM sysman.mgmt_privs
ORDER BY 2,1;
set serveroutput on
DECLARE
x sysman.smp_emd_string_array;
BEGIN
FOR n IN 0 .. 6 LOOP
sysman.mgmt_user.get_privs(n, 0, x);
FOR i IN 1 .. x.COUNT LOOP
dbms_output.put_line('Priv Type ' || TO_CHAR(n) || ': ' || x(i));
END LOOP;
END LOOP;
END;
/ |
| |
| GET_READ_LOCK |
| Undocumented |
mgmt_user.get_read_lock(exception_id_in IN NUMBER) RETURN VARCHAR2; |
| TBD |
| |
| GET_REPORT_DEF_PREDICATE |
| Undocumented |
mgmt_user.get_report_def_predicate(p_schema IN VARCHAR2, p_object IN VARCHAR2)
RETURN VARCHAR2; |
| TBD |
| |
| GET_REPORT_GRANTS |
| Undocumented |
mgmt_user.get_report_grants(
report_id_in IN VARCHAR2,
owner_out OUT VARCHAR2,
grantees_out OUT REF CURSOR); |
| TBD |
| |
| GET_REPOSITORY_OWNER |
| Returns the owner of the OEM repository schema |
mgmt_user.get_repository_owner RETURN VARCHAR2; |
SELECT mgmt_user.get_repository_owner
FROM dual; |
| |
| GET_REPOSITORY_TARGETS |
| Undocumented |
mgmt_user.get_repository_targets RETURN sysman.mgmt_user_guid_array; |
SELECT mgmt_user.get_repository_targets
FROM dual; |
| |
| GET_ROLES |
| Undocumented |
mgmt_user.get_roles(roles_out OUT REF CURSOR); |
set serveroutput on
DECLARE
rc SYS_REFCURSOR;
TYPE array_t IS TABLE OF sysman.mgmt_roles%ROWTYPE
INDEX BY BINARY_INTEGER;
roles_array array_t;
BEGIN
mgmt_user.get_roles(rc);
FETCH rc BULK COLLECT INTO roles_array;
FOR i IN roles_array.FIRST .. roles_array.LAST LOOP
dbms_output.put_line(roles_array(i).role_name || '-' || roles_array(i).description);
END LOOP;
END;
/ |
| |
| GET_ROLES_FOR_ROLE |
| Undocumented |
mgmt_user.get_roles_for_role(
role_name_in IN VARCHAR2,
available_roles_out OUT REF CURSOR,
granted_roles_out OUT REF CURSOR); |
| TBD |
| |
| GET_ROLE_GRANTS |
| Undocumented |
mgmt_user.get_role_grants(
role_name_in IN VARCHAR2,
privs_out OUT REF CURSOR,
roles_out OUT REF CURSOR); |
| TBD |
| |
| GET_ROLE_PRIVS |
| Undocumented |
mgmt_user.get_role_privs(
role_name_in IN VARCHAR2,
priv_type_in IN NUMBER,
user_defined_in IN NUMBER,
privs_out OUT REF CURSOR,
user_names_out OUT REF CURSOR); |
| TBD |
| |
| GET_ROLE_USERS |
| Undocumented |
mgmt_user.get_role_users(
role_name_in IN VARCHAR2,
available_users_out OUT REF CURSOR,
granted_users_out OUT REF CURSOR); |
| TBD |
| |
| GET_STORED_REPORT_PREDICATE |
| Undocumented |
mgmt_user.get_stored_report_predicate(p_schema IN VARCHAR2, p_object IN VARCHAR2)
RETURN VARCHAR2; |
| TBD |
| |
| GET_SUBTAB_PREFS_ALIAS |
| Undocumented |
mgmt_user.get_subtab_prefs_alias(user_name_in IN VARCHAR2, subtab_name_in IN VARCHAR2)
RETURN VARCHAR2; |
| TBD |
| |
| GET_TARGETS |
Undocumented
Overload 1 |
mgmt_user.get_targets(
user_name_in IN VARCHAR2,
target_type_in IN VARCHAR2,
priv_name_in IN VARCHAR2)
RETURN REF CURSOR |
| TBD |
| Overload 2 |
mgmt_user.get_targets(target_type_in IN VARCHAR2, priv_name_in IN VARCHAR2)
RETURN REF CURSOR; |
| TBD |
| |
| GET_TARGETS_FOR_ROLE |
| Undocumented |
mgmt_user.get_targets_for_role(role_name_in IN VARCHAR2, targets_out OUT REF CURSOR); |
| TBD |
| |
|
GET_TARGETS_FOR_USER |
| Undocumented |
mgmt_user.get_targets_for_user(user_name_in IN VARCHAR2, targets_out OUT REF CURSOR); |
| TBD |
| |
| GET_TARGET_PRIVS |
| Undocumented |
mgmt_user.get_target_privs(
roles_in IN sysman.smp_emp_string_array,
targets_in IN sysman.mgmt_user_guid_array,
privs_out OUT REF CURSOR); |
| TBD |
| |
| GET_TARGET_TYPES |
| Undocumented |
mgmt_user.get_target_types(priv_name_in IN VARCHAR2) RETURN REF CURSOR; |
SELECT priv_name, description
FROM sysman.mgmt_privs
ORDER BY 1;
col target_type format a24
col type_display_nlsid format a26
SELECT target_type, type_display_nlsid
FROM sysman.mgmt_target_types;
set serveroutput on
DECLARE
rc SYS_REFCURSOR;
TYPE tt_t IS TABLE OF sysman.mgmt_target_types.target_type%TYPE
INDEX BY BINARY_INTEGER;
tt_array tt_t;
TYPE tdn_t IS TABLE OF sysman.mgmt_target_types.type_display_nlsid%TYPE
INDEX BY BINARY_INTEGER;
tdn_array tdn_t;
BEGIN
rc := mgmt_user.get_target_types('FULL_TARGET');
FETCH rc BULK COLLECT INTO tt_array, tdn_array;
FOR i IN tt_array.FIRST .. tt_array.LAST LOOP
dbms_output.put_line(tt_array(i) || ' - ' || tdn_array(i));
END LOOP;
END;
/ |
| |
| GET_TEMPLATE_PREDICATE |
| Undocumented |
mgmt_user.get_template_predicate(p_schema IN VARCHAR2, p_object IN VARCHAR2)
RETURN VARCHAR2; |
| TBD |
| |
| GET_USERS |
| Undocumented |
mgmt_user.get_users(
user_names_out OUT REF CURSOR,
user_type_in IN NUMBER,
p_user_srch IN VARCHAR2); |
| TBD |
| |
| GET_USERS_DBCONSOLE |
| Undocumented |
mgmt_user.get_users_dbconsole(user_names_out OUT REF CURSOR, p_user_srch IN VARCHAR2); |
| TBD |
| |
| GET_USER_JOB_PRIV |
| Undocumented |
mgmt_user.get_user_job_priv(
job_id IN RAW,
user_name_in IN VARCHAR2,
admin_out OUT VARCHAR2,
priv_out OUT VARCHAR2); |
| TBD |
| |
| GET_USER_OBJECTS |
| Undocumented |
mgmt_user.get_user_objects(user_name_in IN VARCHAR2) RETURN sysman.mgmt_user_objects; |
| TBD |
| |
| GET_USER_PRIVS |
| Undocumented |
mgmt_user.get_user_privs(
user_name_in IN VARCHAR2,
priv_type_in IN NUMBER,
user_defined_in IN NUMBER,
privs_out OUT REF CURSOR); |
| TBD |
| |
| GET_USER_ROLES |
| Undocumented |
mgmt_user.get_user_roles(user_name_in IN VARCHAR2, roles_out OUT REF CURSOR); |
| TBD |
| |
| GET_USER_ROLE_LIST |
| Undocumented |
mgmt_user.get_user_role_list(
p_given_object_name IN VARCHAR2,
p_object_name OUT sysman.varchar2_table,
p_object_description OUT sysman.varchar2_table); |
| TBD |
| |
| GRANT_CA_PRIVS |
| Undocumented |
mgmt_user.grant_ca_privs(
p_guid_in IN RAW,
p_scope_in IN NUMBER,
p_target_guid_in IN RAW,
p_template_guid_in IN RAW,
p_owner_in IN VARCHAR2); |
| TBD |
| |
| GRANT_FULL_JOB_TO_OWNER |
| Undocumented |
mgmt_user.grant_full_job_to_owner(guid_in IN RAW); |
| TBD |
| |
| GRANT_PRIV |
Undocumented
Overload 1 |
mgmt_user.grant_priv(
grantee_in IN VARCHAR2,
priv_name_in IN VARCHAR2,
guid_in IN RAW,
invalidate_in IN NUMBER); |
| TBD |
| Overload 2 |
mgmt_user.grant_priv(
grantee_in IN VARCHAR2,
priv_name_in IN VARCHAR2,
target_name_in IN VARCHAR2,
target_type_in IN VARCHAR2,
invalidate_in IN NUMBER); |
| TBD |
| |
| GRANT_PRIVS |
| Undocumented |
mgmt_user.grant_privs(
grantee_in IN VARCHAR2,
privileges_in IN sysman.mgmt_user_privileges); |
| TBD |
| |
| GRANT_ROLE |
| Undocumented |
mgmt_user.grant_role(
grantee_in IN VARCHAR2,
role_name_in IN VARCHAR2,
with_admin_in IN NUMBER,
invalidate_in IN NUMBER); |
| TBD |
| |
| GRANT_ROLES |
| Undocumented |
mgmt_user.grant_roles(p_grantee IN VARCHAR2, p_roles IN sysman.mgmt_short_string_array); |
| TBD |
| |
| HANDLE_TARGET_DELETED |
| Undocumented |
mgmt_user.handle_target_deleted(
target_name_in IN VARCHAR2,
target_type_in IN VARCHAR2,
target_guid_in IN RAW); |
| TBD |
| |
| HAS_PRIV |
Undocumented
Overload 1 |
mgmt_user.has_priv(
user_name_in IN VARCHAR2,
priv_name_in IN VARCHAR2,
guid_in IN RAW);
RETURN NUMBER; |
| TBD |
| Overload 2 |
mgmt_user.has_priv(
user_name_in IN VARCHAR2,
priv_name_in IN VARCHAR2,
target_name_in IN VARCHAR2,
target_type_in IN VARCHAR2,
RETURN NUMBER; |
| TBD |
| Overload 3 |
mgmt_user.has_priv(
user_name_in IN VARCHAR2,
priv_name_in IN VARCHAR2,
target_guids_in IN sysman.mgmt_user_guid_array);
RETURN REF CURSOR; |
| TBD |
| |
| HAS_PRIV_ON_ALL |
| Undocumented |
mgmt_user.has_priv_on_all(
user_name_in IN VARCHAR2,
priv_name_in IN VARCHAR2,
target_guids_in IN sysman.mgmt_user_guid_array);
RETURN NUMBER; |
| TBD |
| |
| HAS_ROLE |
Returns 1 if the user has the role: Else 0.
Except that it does not seem to work that way. |
mgmt_user.has_role(
user_name_in IN VARCHAR2,
role_name_in IN VARCHAR2,
with_admin_in IN NUMBER)
RETURN NUMBER; |
desc sysman.mgmt_roles
SELECT mgmt_user.has_role('SCOTT', 'PUBLIC', 0)
FROM dual; |
| |
| INVALIDATE_USERS |
| Undocumented |
mgmt_user.invalidate_users(modified_role_name_in IN VARCHAR2); |
| TBD |
| |
| JOB_DELETED |
| Undocumented |
mgmt_user.job_deleted(job_guid_in IN RAW); |
| TBD |
| |
| MAKE_EM_USER |
Undocumented
Overload 1 |
mgmt_user.make_em_user(
user_name_in IN VARCHAR2,
email_addresses_in IN sysman.smp_emd_string_array,
roles_in IN sysman.smp_emd_string_array,
privileges_in IN sysman.mgmt_user_privileges); |
| TBD |
| Overload 2 |
mgmt_user.make_em_user(
user_name_in IN VARCHAR2,
email_address_in IN VARCHAR2,
roles_in IN sysman.smp_emd_string_array,
privileges_in IN sysman.mgmt_user_privileges); |
| TBD |
| |
| MAKE_EM_USER_DBCONSOLE |
| Undocumented |
mgmt_user.make_em_user_db_console(
user_name_in IN VARCHAR2,
email_addresses_in IN sysman.smp_emd_string_array,
roles_in IN sysman.smp_emd_string_array,
privileges_in IN sysman.mgmt_user_privileges,
to_grant_db_priv_in IN NUMBER); |
| TBD |
| |
MODIFY_DBCONSOLE_USER (new in 11.2.0.2)  |
| Undocumented |
mgmt_user.modify_dbconsole_user(
user_name_in IN VARCHAR2,
password_in IN VARCHAR2,
email_addressess_in IN sysman.smp_emd_string_array,
roles_in IN sysman.smp_emd_string_array,
privileges_in IN sysman.mgmt_user_privileges,
to_grant_db_role_in IN NUMBER); |
| TBD |
| |
| MODIFY_JOB_GRANTS |
| Undocumented |
mgmt_user.modify_job_grants(
job_id_in IN RAW,
replace_in IN VARCHAR2,
grant_name_in IN sysman.smp_emd_nvpair_array); |
| TBD |
| |
| MODIFY_ROLE |
| Undocumented |
mgmt_user.modify_role(
role_name_in IN VARCHAR2,
description_in IN VARCHAR2,
roles_in IN sysman.smp_emd_string_array,
privileges_in IN sysman.mgmt_user_privileges,
users_in IN sysman.smp_emd_string_array); |
| TBD |
| |
| MODIFY_USER |
Undocumented
Overload 1 |
mgmt_user.modify_user(
user_name_in IN VARCHAR2,
password_in IN VARCHAR2,
email_addresses_in IN sysman.smp_emd_string_array,
roles_in IN sysman.smp_emd_string_array,
privileges_in IN sysman.mgmt_user_privileges); |
| TBD |
| Overload 2 |
mgmt_user.modify_user(
user_name_in IN VARCHAR2,
password_in IN VARCHAR2,
email_address_in IN VARCHAR2,
roles_in IN sysman.smp_emd_string_array,
privileges_in IN sysman.mgmt_user_privileges); |
| TBD |
| |
| NESTED_JOB_ADDED |
| Undocumented |
mgmt_user.nested_job_added(
parent_job_id IN RAW,
nested_job_id IN RAW); |
| TBD |
| |
| NESTED_JOB_DELETED |
| Undocumented |
mgmt_user.nested_job_deleted(nested_jobid_in IN RAW); |
| TBD |
| |
| RELEASE_READ_LOCK |
| Undocumented |
mgmt_user.release_read_lock(lock_handle_in IN VARCHAR2) RETURN NUMBER; |
| TBD |
| |
| REMOVE_CALLBACK |
| Undocumented |
mgmt_user.remove_callback(proc_in IN VARCHAR2, type_in IN NUMBER); |
| TBD |
| |
| REPORT_DEFINITION_DELETED |
| Undocumented |
mgmt_user.report_definition_deleted(report_guid_in IN RAW); |
| TBD |
| |
| REVOKE_PRIV |
Undocumented
Overload 1 |
mgmt_user.revoke_priv(
grantee_in IN VARCHAR2,
priv_name_in IN VARCHAR2,
guid_in IN RAW,
invalidate_in IN NUMBER); |
| TBD |
| Overload 2 |
mgmt_user.revoke_priv(
grantee_in IN VARCHAR2,
priv_name_in IN VARCHAR2,
target_name_in IN VARCHAR2,
target_type_in IN VARCHAR2,
invalidate_in IN NUMBER); |
| TBD |
| |
| REVOKE_PRIVS |
| Undocumented |
mgmt_user.revoke_privs(
grantee_in IN VARCHAR2,
privileges_in IN sysman.mgmt_user_privileges); |
| TBD |
| |
| REVOKE_ROLE |
| Undocumented |
mgmt_user.revoke_role(
grantee_in IN VARCHAR2,
role_name_in IN VARCHAR2,
invalidate_in IN NUMBER); |
| exec mgmt_user.revoke_role('UWCLASS','DBA',1); |
| |
| REVOKE_ROLES |
| Undocumented |
mgmt_user.revoke_roles(
p_grantee IN VARCHAR2,
p_roles IN sysman.mgmt_short_string_array); |
| TBD |
| |
| REVOKE_VIEW_REPORT_ALL |
| Undocumented |
mgmt_user.revoke_view_report_all(report_id_in IN RAW, owner_in IN VARCHAR2); |
| TBD |
| |
| SET_EM_USER_CONTEXT |
| Undocumented |
mgmt_user.set_em_user_context(em_client_in IN VARCHAR2, op_in IN NUMBER); |
SELECT * FROM v$context;
exec mgmt_user.set_em_user_context(USER, 1);
exec setemusercontext(USER, 1);
SELECT * FROM v$context;
exec mgmt_user.set_em_user_context(USER, 1); |
| |
| TARGET_ASSOC_CHANGED |
| Undocumented |
mgmt_user.target_assoc_changed(
source_target_guid_in IN RAW,
assoc_target_guids_in IN sysman.mgmt_user_guid_array,
change_in IN NUMBER); |
| TBD |
| |
| TEMPLATE_DELETED |
| Undocumented |
mgmt_user.template_deleted(template_guid_in IN RAW); |
| TBD |
| |
| UPDATE_FLAT_ROLE_GRANTS |
| Undocumented |
mgmt_user.update_flat_role_grants(role_name_in IN VARCHAR2); |
| TBD |
| |
| UPDATE_PRIVILEGE |
| Undocumented |
mgmt_user.update_privilege(
p_target_name IN VARCHAR2,
p_target_type IN VARCHAR2,
p_type IN VARCHAR2,
p_new_object_name IN sysman.varchar2_table,
p_new_object_priv IN sysman.varchar2_table,
p_changed_object_name IN sysman.varchar2_table,
p_changed_object_priv IN sysman.varchar2_table,
p_previous_object_name IN sysman.varchar2_table,
p_previous_object_priv IN sysman.varchar2_table,
p_revoked_object_name IN sysman.varchar2_table,
p_revoked_object_priv IN sysman.varchar2_table); |
| TBD |
| |
| UPDATE_PRIVILIGE |
| Undocumented |
mgmt_user.update_privilige(
p_target_name IN VARCHAR2,
p_target_type IN VARCHAR2,
p_type IN VARCHAR2,
p_object_name IN sysman.varchar2_table,
p_object_priv IN sysman.varchar2_table); |
| TBD |
| |
| UPDATE_REVOKE_GRANT_PRIVILEGE |
| Undocumented |
mgmt_user.update_revoke_grant_privilege(
p_guid IN RAW,
p_revoke_or_grant IN VARCHAR2,
p_object_name IN sysman.varchar2_table,
p_object_priv IN sysman.varchar2_table); |
| TBD |
| |
| UPDATE_USER_PREF_EMAIL |
Undocumented
Overload 1 |
mgmt_user.update_user_pref_email(
user_name_in IN VARCHAR2,
user_email_in IN sysman.smp_emd_string_array); |
| TBD |
| Overload 2 |
mgmt_user.update_user_pref_email(
user_name_in IN VARCHAR2,
user_email_in IN sysman.smp_emd_string_array,
user_email_format_in IN sysman.smp_emd_string_array); |
| TBD |
| |
| VALID_GROUP_MEMBER |
Undocumented
Overload 1 |
mgmt_user.valid_group_member(
group_guid_in IN RAW,
member_guid_in IN RAW)
RETURN NUMBER; |
| TBD |
| Overload 2 |
mgmt_user.valid_group_member(
group_guid_in IN RAW,
member_target_name_in IN VARCHAR2,
member_target_type_in IN VARCHAR2)
RETURN NUMBER; |
| TBD |
