MSCEWI4064
XP_LOGININFO mapped to custom UDF
Last updated
XP_LOGININFO mapped to custom UDF
Last updated
This is a deprecated version of the SnowConvert documentation, please visit the official site .
Low
This EWI is added when the XP_LOGININFO procedure is executed and returns the following set of columns ()
account name
type
privilege
mapped login name
permission path
To simulate this behavior, we select the columns from the APPLICABLE_ROLES view in SnowFlake, which returns the following set of columns ()
GRANTEE
ROLE_NAME
ROLE_OWNER
IS_GRANTABLE
SQL Server original columns are mapped as shown in the next table. They may be not completely equivalent.
account name
GRANTEE
type
ROLE_OWNER
privilege
ROLE_NAME
mapped login name
GRANTEE
permission path
NULL
No additional user actions are required.
If you need more support, you can email us at