Security audit in SQL server captures only successful and failed logins. It does not capture the application that uses the login. Login used by an application may have full read and write access on all of the tables and procedures but the application restricts the users by providing a front-end whic
Author: SSWUG Research
Managing Users Permissions
By Alexander Chigrik – Permissions are the rights to access the database objects. Permissions can be granted to a user or role to allow that user or role to perform operations such as selection, insertion, or modification of data rows. Each database object has an owner. By default, the owner
Tools for Combating the Slammer Worm
Microsoft is working to help customers secure their networks against the Slammer worm. Software tools and other resources designed to help secure installations of SQL Server and Microsoft SQL Server 2000 Desktop Engine (MSDE 2000) will be added to this page as they become available.
Microsoft Targets J2EE Users with JLCA 2.0
By Thor Olavsrud – Continuing its efforts to migrate organizations from the J2EE platform into the .NET camp, Microsoft Tuesday launched Java Language Conversion Assistant (JLCA) 2.0, the latest version of a tool geared to smoothing the path for Java language developers to work with Web services and
PyXML 0.8.3
Open source collection of libraries to process XML with Python. There are many bug fixes in this release.
Divide and conquer large XML documents
by Benoît Marchal – Occasionally, you get an XML file that is too large to publish as is. The solution is to use your XSLT processor to break the file into smaller documents. This tip demonstrates how to break up documents with popular XSLT processors.
Secure SQL Server: Installing for security
By Susan Harkins – Securing SQL Server is vital to the design of any database system. Learn how to install SQL securely, protect data, and ensure its validity.
Heavy-Duty Database Showdown: The Microsoft Challenge
By Robyn Weisman – Part 1 of this article discussed the relative advantages and disadvantages of IBM’s DB2 and Oracle’s 9i software. However, IBM and Oracle, with their combined 70 percent market share, are not the only RDBMS vendors in the database race.
Oracle Seeks to Postpone PeopleSoft Suit
By Lisa Vaas – Oracle Corp. has asked the Delaware Chancery Court to postpone, indefinitely, a hearing for its case against PeopleSoft Inc. The case is an attempt by Oracle to prevent PeopleSoft from exercising its so-called poison pill—which is a stock-related maneuver that would torpedo Ora
Oracle Announces Application Server Sales Milestone
In a recent press release, Oracle Corp. announced a new sales record for Oracle9i Application Server. Oracle has signed more than 3,000 new Oracle9i Application Server customers during its past three quarters. The Oracle9i Application Server customer base now totals 16,000.