Re: truncate table command

If you grant a user DROP ANY TABLE privileges, what's to keep that user from actually *dropping* a table in someone else's schema? What's to keep that user from dropping a table in the SYS or SYSTEM schemas?

Just curious.

--Erich

JM Peale <jackiep_at_rkeng.com> wrote in article <01bcc39f$8d7235e0$1afcfcdd_at_jackiep>...
>
> I believe you must also grant DROP ANY TABLE as well. I had this problem
> and I added the DROP grant. You also have to specify the owner of the
> table when doing the actual truncate, i.e., if you are calling a.SQL
> script, you have to call it with a parameter. Thus, inside of the .SQL
> script you will have
>
> TRUNCATE TABLE &1.NAMEOFTABLE
>
> I have table owners like "NAME_DB". If you also have an underscore in
 your
> owner name, you would do the following:
>
> TRUNCAT TABLE &1._DB.NAMEOFTABLE.
>
> Hope this helps.
>
> Jackie Peale
>
>
> Philippe Mendes <EURO.FINANCE_at_wanadoo.fr> wrote in article
> <341FE624.E63FD5BE_at_wanadoo.fr>...
> > What is the way to permit to an none dba user to do a 'truncate table'
> > on a table of an other user ?
> > Which privileges must i give to the user.
> > I have try to do an 'grant delete any table' but it has done no change.
> >
> > thanks for helping me.
> >
> >
>
  Received on Thu Sep 18 1997 - 00:00:00 CDT