ListUserColumnPermissions Method

This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.

The ListUserColumnPermissions method returns a SQLObjectList object that enumerates column-level access permissions for a specified Microsoft SQL Server database role or user.

Syntax

object
.ListUserColumnPermissions(
UserName 
)
as
SQLObjectList

Parts

• object
  Expression that evaluates to an object in the Applies To list.

• UserName
  String that specifies an existing user-defined database role in SQL Server, or user by name.

Prototype (C/C++)

HRESULT ListUserColumnPermissions(
SQLDMO_LPCSTR UserName, 
LPSQLDMOPERMISSIONLIST * ppList);

Returns

A SQLObjectList object that contains Permission objects.

Remarks

The ListUserColumnPermissions method enumerates object-access permissions granted explicitly.

SQL Server and database roles assign permissions by granting statement execution permissions implicitly. Implicit grants are not enumerated by the ListUserPermissions method.

Applies To: