Thursday, March 29, 2012

attach db in stored proc

Hi all,
I want a nonpriviliged owner to attach a specific database. I put the attach
command in a stored proc. How do I grant priviliges to that stored proc so
the user can exec it?
Thanks
FrankNo can do. Only users with symin or dbcreator server role can invoke
sp_attach_db.
-oj
"Frank" <frank@.frank.com> wrote in message
news:42668e6b$0$98488$e4fe514c@.news.xs4all.nl...
> Hi all,
> I want a nonpriviliged owner to attach a specific database. I put the
> attach command in a stored proc. How do I grant priviliges to that stored
> proc so the user can exec it?
> Thanks
> Frank
>sql

No comments:

Post a Comment