Re: deleting large databases

>From: uunet!ortarg.edu.ar!yaron (Yaron Zarfati) >Subject: deleting large databses >Date: Mon, 14 Dec 92 14:33:44 ARG >X-Informix-List-Id: <list.1698> >Hello, I am working in 4GL 4.00 under UNIX ... > Another solution was to drop and re-create the table, which would be > the fastest way, and worked fine. > But now I have to work on the security aspect, and all the databases > were re-created by a database administrator, giving INSERT, DELETE,... > privileges but I can't DROP TABLES, DROP INDEXES, CREATE TABLES, CREATE > INDEXES, without having RESOURCE privilege on the whole database, not > only the table I am working with. > Does somebody know of a workaround for this situation ??? The "obvious" solution involves an engine upgrade and possibly an tools upgrade. If you have the 5.00 engines (SE or OnLine), you can create a DBA-privileged stored procedure which can be used to allow the CONNECT-level user of the procedure permission to do things like DROP TABLE, CREATE TABLE which only a RESOURCE-level user or DBA can normally do. And, of course, you can grant only certain individuals the right to execute the procedure, etc. You can execute procedures from 4.00 or 4.10 I4GL, but the statements have to be prepared. The procedures described above would be executed, but if the procedure returns multiple rows of data, you would need to declare a cursor for the prepared statement, and then open, fetch and close it. You would free the prepared statement when you had finished with it. No version 4.xx product will support stored procedures directly (though ISQL will look a little as if it does, but only because it is using prepare, etc.) Yours, Jonathan Leffler (johnl@obelix.informix.com) #include <disclaimer.h>