By RAJASEKHARA RAO ALURU – This procedure gives information about the objects being dropped from a database, such as the name and type of the object, the user who is dropping the object, terminal, etc. Here’s what to do:
Author: SSWUG Research
Microsoft Patch Fixes Critical MCMS Flaws
By Dennis Fisher – Microsoft Corp. issued a patch for three critical vulnerabilities in one of its .Net servers, the Microsoft Content Management Server 2001 (MCMS). Potentially the most serious of the three is a SQL injection vulnerability in a function that responds to requests for images a
Using Views to Control User Access to Data
I have a Microsoft Access 2000 application that is populated by a back-end SQL Server 2000 database. To prevent Access users from viewing all the data in a SQL Server 2000 table, I want to use a view that displays only the data rows the user has been authorized to see. Can I create a view that limit
Index maintenance
By Baya Pavliashvili – The easiest and oldest way to maintain indexes is to drop and recreate them. If your application has hundreds or even thousands of tables with a few indexes on each it would be quite a task to go through each one of them and recreate the indexes. The larger the table the longe
Enterprises Will Walk, Not Run, to 9i
By Anne Chen – Although Release 2 of Oracle9i offers advantages over earlier Oracle versions, experts expect that depressed IT budgets and normal enterprise caution will mean most users won’t migrate to the new database until the end of next year or early 2004.
Finding the First, Last, Biggest, Smallest
by Bob DuCharme – Sometimes you want to know which element or record is first or last in a given set, or you want to know which element or record has a value that is the greatest or smallest among the corresponding values in that set — for example, which employee element has the lowest value for a
XML for Data: XSLT 2.0: An early look
In this column, Kevin Williams takes a look at the latest working draft for XSLT 2.0 and provides some code samples that show just how useful the new version of the XML styling language can be.
Topic Maps for the Web
Addison-Wesley has released ‘XML Topic Maps: Creating and Using Topic Maps for the Web’, described as a complete introduction and application guide to the world of topic maps. Edited by Jack Park and Sam Hunting, the book introduces the topic maps paradigm, global federated knowledge interchange, to
Using Web Services with Oracle9i Reports
This tutorial provides steps to using a currency conversion Web service in an enterprise report built with Oracle9i Reports.
Using DTS to Automate a Data Import Process
From SQLTeam – In this article I show you how to create a DTS Package that can be used to automate a file download/import process. It’s a little longer than the other articles I have written for SQLTeam and will require some work on your part if you want to implement it, but I think you will find it