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
Thursday, March 29, 2012
attach db in stored proc
Labels:
attach,
attachcommand,
database,
grant,
microsoft,
mysql,
nonpriviliged,
oracle,
owner,
priviliges,
proc,
server,
specific,
sql,
stored
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment