Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
gdeswardt
Starting Member
3 Posts |
 Posted - 2002-03-11 : 06:32:59
|
| HiI am writing a small app in VB6 and I am stuck with the problem of showing all the members of a dayabaserole. Currently the user clicks on the databaserole they want to examine and a list box should then display all the users for that role.Any help will be appreciated.RegardsGert |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-03-11 : 08:54:57
|
| I can't find a method in SQL-DMO that does this, however you can run the sp_helprolemember system procedure and pass the role name you need:sp_helprolemember 'GoodGuys'This will list all the members of the "GoodGuys" role (if you had this role). Books Online has more information on sp_helprolemember. |
 |
|
|
|
|
|
DatabaseRole members in SQL-DMO