Newly Created Child Domain Adding User_menu_access Records From Parent & Sub Domains (Doc ID 2993821.1)

Last updated on JULY 20, 2024

Applies to:

Symptoms

When a new sub domain is created, it adds the user_access & user_menu_access records from its Parent domain as well as other pre existing sub domains.
Customer ran the below sql to verify the same

select uma.user_menu_layout_gid, ua.user_access_gid, uma.domain_name, ua.gl_level, ua.user_role_gid, ua.gl_user_gid,
ua.is_lockdown, ua.is_override, ua.access_type, ua.insert_user, ua.insert_date, ua.update_user, ua.update_date
from user_access ua, user_menu_access uma where ua.user_access_gid = uma.user_access_gid and ua.domain_name in ('<Domain_name>')
order by 3

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.