Hello,
I am looking to have the developers at my company start to use
application roles to gain access to SQL. The basics seem simple, add the
role to the database, use sp_setapprole to activate it.
My question is most likely really simple as well...
How do you tell the application which SQL server you want to EXEC
sp_setapprole against?
i.e. do you need to establish an OLEDB connection before calling
sp_setapprole? Seems strange to have to establish a connection twice,
but I can't think of how else to do it. But I think I'm missing
something...
Thanks in advance!
TGru
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
I am looking to have the developers at my company start to use
application roles to gain access to SQL. The basics seem simple, add the
role to the database, use sp_setapprole to activate it.
My question is most likely really simple as well...
How do you tell the application which SQL server you want to EXEC
sp_setapprole against?
i.e. do you need to establish an OLEDB connection before calling
sp_setapprole? Seems strange to have to establish a connection twice,
but I can't think of how else to do it. But I think I'm missing
something...
Thanks in advance!
TGru
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!