Re: insufficient privileges when tryning to truncate table.

From: Connor McDonald <mcdonald.connor.cs_at_bhp.com.au>
Date: Wed, 24 Jun 1998 15:58:10 +0800
Message-ID: <3590B192.3CB8@bhp.com.au>

rune.slinning_at_bigfoot.com wrote:
>
> Hi!
>
> I have an Oracle 7.3.3 installation with three schemas, adb, cdb and dfo. I
> have defined 3 users with the same name as the schemas which owns the tables
> in their schemas.
>
> From SQL plus, logged in as user adb, I tried to truncate a table in schema
> cdb, I'll get the follwing error message:
>
> SQL> truncate table cdb.unit;
> truncate table cdb.unit
> *
> ERROR at line 1:
> ORA-01031: insufficient privileges
>
> SQL>
>
> According to the Oracle manuals, the users must be granted delete table to be
> able to truncate the table. The adb user is given the following grant:
>
> grant select any table to adb;
> grant delete any table to adb;
> grant update any table to adb;
> grant insert any table to adb;
>
> Do anybody know why user adb can't truncate tables in schema cdb?
>
> Rune
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/ Now offering spam-free web-based newsreading

1. You need "drop any table".......Ugh!
2. You can get around (a) by using dbms_sql inside a proc owned by cdb and granted to adb.

Cheers
Connor
--

---

Connor McDonald
BHP Information Technology
Perth, Western Australia
"These views mine not BHP..etc etc"

"The only difference between me and a madman is that I am not mad." Received on Wed Jun 24 1998 - 02:58:10 CDT