Re: Permission question

From: KRISHNAN GANESAN <KRISHNANG_at_MSN.COM>
Date: 1998/02/27
Message-ID: <u5FELn$Q9GA.204@upnetnews04>#1/1

"Drop any table" system privilege is required to truncate tables owned by other users.
You know the consequences of granting such a privilege to non DBAs.

Krish

Jim Finch wrote in message <34F4E42C.88BFC6B2_at_neo.lrun.com>...
>It is my understanding that any user with Delete privs on a table can
>truncate it. I have users with select, update, insert, delete privs on a
>table. They can do all (select, update, delete and insert) but not
>trucate. They get insificient priv. What priv are they lacking.
>
>Jim Finch
>
>email to jfinch_at_calibersys.com
>
Received on Fri Feb 27 1998 - 00:00:00 CST