PL/SQL

From: Norman Dunbar <Norman.Dunbar_at_lfs.co.uk>
Date: Fri, 2 May 2003 10:26:33 +0100
Message-ID: <E2F6A70FE45242488C865C3BC1245DA703A00A96@lnewton.leeds.lfs.co.uk>

Morning Admiral,

you are most likely hitting the old problem wherby a user can create a table in SQLPlus, but not in a PL/SQL procedure. This is because the create table privs have been granted to the user through a role, and in PL/SQL role privs are essentially turned off. Just to make it interesting, they are not turned off in an anonymous PL/SQL block !

Your user needs to be explicitly granted create table, not through a role.

Cheers,
Norm.

PS. You didn't mention which version, but if you need to create a table temporaily, check out create [global] temporary table.

Norman Dunbar
Database/Unix administrator
Lynx Financial Systems Ltd.
mailto:Norman.Dunbar_at_LFS.co.uk

Tel: 0113 289 6265
Fax: 0113 289 3146
URL: http://www.Lynx-FS.com


-------------------------------------

-----Original Message-----
From: admiral_freebee_at_hotmail.com (Hervé Ferreira) [mailto:admiral_freebee_at_hotmail.com]
Posted At: Friday, May 02, 2003 9:40 AM
Posted To: server
Conversation: PL/SQL
Subject: PL/SQL

Hello,

I want to create a table in a pl/sql procedure to store the output while I gather it, but i'm having trouble with creating a table in my procedure. How could i solve this? Received on Fri May 02 2003 - 04:26:33 CDT