Retrieve membership using TSQL

[Pierre Van der Steichel]

Hi,

Pretty new at SQL server.
Is it possible to retrieve role membership for a user using SQL or TSQL and what privileges weill that require.

I did the same thing using SQLDMO but not an acceptable solution
for current requirement (additional granularity in a profiling service)

Any help will be appreciated,

Pierre

See sp_helprolemember in your documentation

------------
Pierre Van der Steichel at 6/8/01 9:04:55 AM


Hi,

Pretty new at SQL server.
Is it possible to retrieve role membership for a user using SQL or TSQL and what privileges weill that require.

I did the same thing using SQLDMO but not an acceptable solution
for current requirement (additional granularity in a profiling service)

Any help will be appreciated,

Pierre