SSC-FDM-TS0003
XP_LOGININFO mapped to custom UDF
Last updated
XP_LOGININFO mapped to custom UDF
Last updated
This message is shown when the XP_LOGININFO procedure is executed and returns the following set of columns ()
account name
type
privilege
mapped login name
permission path
To replicate this behavior, there is a query that 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
If you need more support, you can email us at