ListPermissions List

SQLServer.Database.StoredProcedure Object

Description

Returns a list of Permission objects containing the privileges for this stored procedure.

Visual Basic

PermissionList = StoredProcedure.ListPermissions ( [[PrivilegeTypes :=] tPrivileges] )

C++

HRESULT pStoredProcedure->ListPermissions (
LPSQLOLEPERMISSIONLIST*
ppPermissionList,
SQLOLE_PRIVILEGE_TYPE
tPrivileges = SQLOLEPriv_Execute );

Elements

Element Type Description

PermissionList PermissionList Returned list of Permission objects
tPrivileges SQLOLE_PRIVILEGE_TYPE Types of stored procedure privileges to list

Reference

sp_helpprotect