lprofile_id

Returns the login profile ID of the specified login profile name, or the login profile ID of the login profile associated with the current login or the specified login name.

Syntax

lprofile_id(name)

Parameters

Examples

Usage

If you:
  • Specify a login profile name – lprofile_id returns the corresponding login profile ID. If you specify a login name, lprofile_id returns the associated (if any) login profile ID.

  • Do not specify namelprofile_id returns the login profile ID of the current login.

Standards

ANSI SQL – Compliance level: Transact-SQL extension.

Permissions

The permission checks for lprofile_id differ based on your granular permissions settings.

Granular PermissionsDescription
Enabled

With granular permissions enabled, any user can execute lprofile_id to return the ID of their own profile. You must have manage any login profile permission to execute lprofile_id and retrieve the profile ID of other users.

Disabled

With granular permissions disabled, any user can execute lprofile_id to return the ID of their own profile. You must be a user with sso_role to execute lprofile_id and retrieve the profile ID of other users.

Related reference
lprofile_name