SSC-FDM-TS0003

XP_LOGININFO mapped to custom UDF

Important Notice: Migration of Documentation Website

Please be advised that our documentation website is currently undergoing a migration to a new platform. To ensure you have access to the most up-to-date information, we kindly request that you visit our new documentation website located at:

Official Snowflake Snowconvert Documentation

For any immediate assistance or if you encounter any issues, please contact our support team at [email protected].

Thank you for your understanding.

Description

This message is shown when the XP_LOGININFO procedure is executed and returns the following set of columns (See SQL SERVER documentation for more info)

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 (See SnowFlake documentation for more info)

SQL Server original columns are mapped as shown in the next table. They may be not completely equivalent.

SQL Server
SnowFlake

account name

GRANTEE

type

ROLE_OWNER

privilege

ROLE_NAME

mapped login name

GRANTEE

permission path

NULL

Example code

Input code:

IN -> SqlServer_01.sql
EXEC xp_logininfo

EXEC xp_logininfo 'USERNAME'

Output code:

OUT -> SqlServer_01.sql
--** SSC-FDM-TS0003 - XP_LOGININFO MAPPED TO CUSTOM UDF XP_LOGININFO_UDF AND MIGHT HAVE DIFFERENT BEHAVIOR **
SELECT
*
FROM
TABLE(XP_LOGININFO_UDF());

--** SSC-FDM-TS0003 - XP_LOGININFO MAPPED TO CUSTOM UDF XP_LOGININFO_UDF AND MIGHT HAVE DIFFERENT BEHAVIOR **
SELECT
*
FROM
TABLE(XP_LOGININFO_UDF('USERNAME'));

Recommendations

Last updated