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-03-15 : 13:11:58
|
Tim writes "Hi
(at first this sounds like a non-SQL question but please read through :)
I have a database maintenance task that requires dbo privileges.
This task is executed from a VBscript file that is scheduled to run periodically on a webserver. The connection string to the database has a password in it. This is of course visible to anyone who manages to download the script file. I don't mind anyone executing the script, i just don't wnat them to see the password (it is dbo!).
So I considered putting the task into a stored procedure and giving a new login execute permission. Now in my script file, I can give the password for the new login that has execute permission to the stored procedure and nothing else.
But.... how will the stored procedure have the dbo privileges required for the task?
If i change the owner of the stored procedure to be the dbo login will that solve my problem?? (using sp_changeobjectowner)
Well I think i might have answered my own question after all that, but I would like a second opinion and maybe it's useful to others also..
Thanks,
Tim." |
|
|
|
|
|
Stored Procedures: Security Shield??