RE: Truncate Privilege
- From: JayMiller@xxxxxxxxxxxxxxxx
- To: BurtonL@xxxxxxxxxxx
- Date: Thu, 28 Apr 2005 11:49:10 -0400
Just in case this wasn't clear you create the pl/sql procedure as the owner
of the table you want truncated and then you grant execute on the procedure
to the user who will be doing the truncating.
Thanks,
Jay Miller
Sr. Oracle DBA
x68355
-----Original Message-----
From: Fuad Arshad [mailto:fuadar@xxxxxxxxx]
Sent: Monday, April 25, 2005 11:54 AM
To: BurtonL@xxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx
Subject: Re: Truncate Privilege
you probably have to give drop any table privilege sine oracle does not have
a truncate table priv(truncate is a ddl).
but if you want to be secure.
create pl/sql procedute that userscan use to truncate specific tables.
"Burton, Laura" <BurtonL@xxxxxxxxxxx> wrote:
Can someone tell me what privilege is needed for a user to truncate a
table that is not owned by that user?
I have looked at Metalink and it states the Drop Any Table privilege,
but this doesn't work either. The user can select, insert, and even
delete from the table. =20
Thank you, Laura
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
