Re: ora-01031 (insuff priv) while create table in package
From: Ana C. Dent <anacedent_at_hotmail.com>
Date: Tue, 15 Jul 2008 01:33:28 GMT
Message-ID: <Xns9ADBBC60CE16Eanacedenthotmailcom@69.28.173.184>
>
> my problem doesn't deal with temp-tables, my example-sql probably
> confuses you.
>
>
> Sorry if I'm explaining too much details:
>
> I've written a package that manage nested sets.
> It uses two tables:
> one for the attributes and the other for the tree structures.
>
> I've written it with dynamical SELECT/INSERT/UPDATES/DELETE
> statements, so that the user can choose the table names and the names
> of essential fields of the attribut-table.
> (there is i.E a SetTabNameTree procedure)
> So he can add nested-functionality to his existing flat tables without
> changing anything.
>
> Now I want to write a service-package that create all tables,
> sequences triggers and views withe the user choosen names.
>
> If it doesn't work, I've to write a client-application to create the
> necessary database-objects, or the user must do it by a
> string-replaces itself.
>
Date: Tue, 15 Jul 2008 01:33:28 GMT
Message-ID: <Xns9ADBBC60CE16Eanacedenthotmailcom@69.28.173.184>
Norbert Winkler <norbert.winkler1_at_gmx.de> wrote in
news:16scv8ynss7k8.1cpgydtlpexsn.dlg_at_40tude.net:
>> >> Why do you want to do this? In general this is a very bad idea. If >> you want a "temporary table" in a manner similar to MS SQLServer uses >> in stored procs then look up global temporary table in the Oracle >> Docs. A global temporary table is created 1 time not by each user.
>
> my problem doesn't deal with temp-tables, my example-sql probably
> confuses you.
>
>> Jim
>
> Sorry if I'm explaining too much details:
>
> I've written a package that manage nested sets.
> It uses two tables:
> one for the attributes and the other for the tree structures.
>
> I've written it with dynamical SELECT/INSERT/UPDATES/DELETE
> statements, so that the user can choose the table names and the names
> of essential fields of the attribut-table.
> (there is i.E a SetTabNameTree procedure)
> So he can add nested-functionality to his existing flat tables without
> changing anything.
>
> Now I want to write a service-package that create all tables,
> sequences triggers and views withe the user choosen names.
>
> If it doesn't work, I've to write a client-application to create the
> necessary database-objects, or the user must do it by a
> string-replaces itself.
>
You have designed an application which does NOT scale & violates many best practices involving RDBMS. Every SQL will have to be dynamically built & executed; never any reuse!
The first rule of holes, is that when you find yourself in a hole the FIRST thing you should do is STOP DIGGING!
I suspect nobody will be able to dissuade you.
You're On Your Own (YOYO)! Received on Mon Jul 14 2008 - 20:33:28 CDT