USP_SYSTEMPRIVILEGECATALOG_GETYBID

Gets a system privilege for the provided ID.

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN

Definition

Copy



create procedure dbo.USP_SYSTEMPRIVILEGECATALOG_GETYBID(@ID uniqueidentifier)
as
    set nocount on;

    select ID, 
        NAME, 
        DESCRIPTION,
        SECURITYUIFOLDER
    from dbo.SYSTEMPRIVILEGECATALOG
    where ID = @ID;