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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-07-04 : 08:28:22
|
| Glen writes "Is it possible to have the assignment of users to a certain role maintained on the application layer level?I want to remove and add certain users to specific sql server roles through my application a NOT through the Enterprise Manager or MS Access.Thanks" |
|
|
jasper_smith
SQL Server MVP & SQLTeam MVY
846 Posts |
Posted - 2003-07-04 : 12:31:52
|
| Sure, you can use SQLDMO or system stored procedures to this e.g. sp_addrolemember , sp_droprolemember.HTHJasper Smith0x73656c6563742027546f6f206d7563682074696d65206f6e20796f75722068616e6473203f27 |
 |
|
|
|
|
|
User Maintenance Through sp_ or application