To display the login profile ID of a specified login profile name or login name, use:
lprofile_id([{login profile name | login name}])
System security officer role is required to view the profile ID of the specified login name if it is not the current user’s login name.
The following displays the login profile name of the specified login profile ID:
select lprofile_id(‘intern_lr’) ------------- 3
If a login profile is not associated with the specified login account, then the profile ID of the default login profile is returned. The login profile ignore parameter must not be set.
