CREATE PROCEDURE [dbo].[GetAllProperties]
@Path nvarchar (425),
@AuthType int
AS
select
   Property,
   Description,
   Type,
   DATALENGTH( Content ),
   ItemID,
   SUSER_SNAME(C.Sid),
   C.UserName,
   CreationDate,
   SUSER_SNAME(M.Sid),
   M.UserName,
   ModifiedDate,
   MimeType,
   ExecutionTime,
   NtSecDescPrimary,
   [LinkSourceID],
   Hidden,
   ExecutionFlag,
   SnapshotLimit,
   [Name]
FROM Catalog
   INNER JOIN Users C ON Catalog.CreatedByID = C.UserID
   INNER JOIN Users M ON Catalog.ModifiedByID = M.UserID
   LEFT OUTER JOIN SecData ON Catalog.PolicyID = SecData.PolicyID AND SecData.AuthType = @AuthType
WHERE Path = @Path

GO
GRANT EXECUTE ON  [dbo].[GetAllProperties] TO [RSExecRole]
GO