Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

insufficient privileges when tryning to truncate table.

708 views
Skip to first unread message

rune.s...@bigfoot.com

unread,
Jun 23, 1998, 3:00:00 AM6/23/98
to

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

Herlina

unread,
Jun 23, 1998, 3:00:00 AM6/23/98
to rune.s...@bigfoot.com

Hi Rune,

it's doc. bug from oracle.
You need 'drop any table' privillege to truncate other scheme table.

Bert Scalzo

unread,
Jun 23, 1998, 3:00:00 AM6/23/98
to

Doc is wrong. User must have DROP ANY TABLE priv.

Connor McDonald

unread,
Jun 24, 1998, 3:00:00 AM6/24/98
to rune.s...@bigfoot.com

a. You need "drop any table".......Ugh!
b. 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."

0 new messages