User permission Query

[msp]

Hi is anyone aware of a query or Stored Procedure I can call that will retrieve all the users and permissions for a particular database.

Thanks for any help.

 

[SQL_Hell]

Hi there

try this

exec sp_helplogins


or this

select * from sysusers