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 - 2001-11-05 : 00:10:19
|
| Nathan writes "I have a problem implementing application role security in our environment because we want to restrict everyone except the DBA group to have access to the application role security password. Since Microsoft does not allow sp_setapprole to be used within a stored procedure (procedure checks the nesting level), I have to write an extended stored procedure to be called by the VB applications. The extended stored procedure will then use a trusted connection to the database with guest permissions and then apply the extended stored procedure which executes the sql command sp_setapprole. I do not Microsoft has several q articles on this topic, primarily Q229564 I'm having problems getting the extended stored procedure to execute correctly. Any ideas?" |
|
|
|
|
|
Extended Stored Procedures in SQL