<Darrilgibson@[EMAIL PROTECTED]
> wrote in message
news:5bd84905-5c2c-485e-a07b-30add9aa5bce@[EMAIL PROTECTED]
> If you're getting ready to take an MCITP exam on SQL Server 2005 (such
> as 70-441, 70-442, 70-444), you'll do better if you have a solid
> understanding of stored procedure permissions.
>
> For example, what's the answer to this question?
>
> Q. You've just developed a stored procedure that can be used to update
> data in the Widgets table or add new Widgets to the Widgets table if
> they don't exist. What permissions are required for someone to use the
> stored procedure? (Choose all that apply).
>
> A. SELECT permission on the Widgets table.
> B. UPDATE permission on the Widgets table.
> C. INSERT permission on the Widgets table.
> D. EXEC permission on the stored procedure.
The answer: It depends.
<g>
--
Lawrence Garvin, M.S., MCBMSP, MCTS, MCP
Senior Data Architect, APQC, Houston, Texas
Microsoft MVP - Software Distribution (2005-2008)
MS WSUS Website: http://www.microsoft.com/wsus
My Websites: http://www.onsitechsolutions.com;
http://wsusinfo.onsitechsolutions.com
My MVP Profile: http://mvp.sup****t.microsoft.com/profile/Lawrence.Garvin
|
