Microsoft Security Bulletin (MS00-048)
Patch Available for "Stored Procedure Permissions" Vulnerability
Originally Posted: July 7, 2000
Microsoft has released a patch that eliminates a security
vulnerability in Microsoft(r) SQL Server 7.0. The vulnerability could
allow a malicious user to run a database stored procedure without
proper permissions.
Frequently asked questions regarding this vulnerability and the patch
can be found at:
http://www.microsoft.com/technet/security/bulletin/fq00-048.asp
Execute permission checks on stored procedures may be bypassed when a
stored procedure is referenced from a temporary stored procedure.
This omission would allow a malicious user to run a stored procedure
that, by design, he should not be able to access.
The vulnerability only occurs under a fairly restricted set of
conditions:
The database and stored procedure must be owned by the system
administrator (sa) login account.
The malicious user must be able to authenticate to the SQL Server,
and have user access to the referenced database.
Microsoft SQL Server 7.0
NOTE: Additional security patches are available at the Microsoft
Download Center
Please see the following references for more information related to
this issue.
This is a fully supported patch. Information on contacting Microsoft
Product Support Services is available at
http://support.microsoft.com/support/contact/default.asp
Microsoft thanks Adina Reeve of Sequiturcorp for reporting this issue
and working with us to protect customers.
THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED
"AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL
WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF
MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT
SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY
DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL,
CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF
MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE
POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION
OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO
THE FOREGOING LIMITATION MAY NOT APPLY.
Last Updated July 7, 2000