RE: Privileges needed for truncate /thanks all

2002-09-25 Thread Jack van Zanen
: Jack van Zanen/nlzanen1/External/MEY/NL) Sent by: Subject: RE: Privileges needed for truncate [EMAIL PROTECTED

RE: Privileges needed for truncate

2002-09-24 Thread Glenn Travis
Gramolini [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 19, 2002 2:18 PM To: Multiple recipients of list ORACLE-L Subject: Re: Privileges needed for truncate To truncate you need delete privileges. Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED

RE: Privileges needed for truncate

2002-09-24 Thread Karniotis, Stephen
: [EMAIL PROTECTED] Web:www.compuware.com -Original Message- Sent: Tuesday, September 24, 2002 1:59 PM To: Multiple recipients of list ORACLE-L Subject:RE: Privileges needed for truncate delete wasn't enough for me. had to grant 'drop any table'. From the Oracle8i SQL

RE: Privileges needed for truncate

2002-09-24 Thread Khedr, Waleed
- Sent: Tuesday, September 24, 2002 1:59 PM To: Multiple recipients of list ORACLE-L Subject:RE: Privileges needed for truncate delete wasn't enough for me. had to grant 'drop any table'. From the Oracle8i SQL Reference Release 3 (8.1.7) manal: To truncate a table or cluster

RE: Privileges needed for truncate

2002-09-24 Thread Ron Rogers
24, 2002 1:59 PM To: Multiple recipients of list ORACLE-L Subject:RE: Privileges needed for truncate delete wasn't enough for me. had to grant 'drop any table'. From the Oracle8i SQL Reference Release 3 (8.1.7) manal: To truncate a table or cluster, the table or cluster must

RE: Privileges needed for truncate

2002-09-19 Thread Jamadagni, Rajendra
Title: RE: Privileges needed for truncate Alter any table Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can

Privileges needed for truncate

2002-09-19 Thread Jack van Zanen
Hi I need to create a user/role that among other stuff must be able to truncate a table. I can't figure out which privileges are needed (DBA is a bit OTT :-)) Try them one by one does not sound appealing at all TIA Jack === De

RE: Privileges needed for truncate

2002-09-19 Thread Khedr, Waleed
Unfortunately drop any table. -Original Message- Sent: Thursday, September 19, 2002 10:24 AM To: Multiple recipients of list ORACLE-L Hi I need to create a user/role that among other stuff must be able to truncate a table. I can't figure out which privileges are needed (DBA is a bit

RE: Privileges needed for truncate

2002-09-19 Thread Bernard, Gilbert
19 septembre 2002 16:24 À: Multiple recipients of list ORACLE-L Objet: Privileges needed for truncate Hi I need to create a user/role that among other stuff must be able to truncate a table. I can't figure out which privileges are needed (DBA

Re: Privileges needed for truncate

2002-09-19 Thread Jay Hostetter
Jack, It used to be DELETE ANY TABLE. I'm not sure if that has changed in recent versions. Long ago, I setup the following procedure to allow a specific table to be truncated, without out the DELETE ANY TABLE privilege. It must be owned by the owner of the table. I haven't dealt with

RE: Privileges needed for truncate

2002-09-19 Thread Bernard, Gilbert
: jeudi 19 septembre 2002 17:24 À: Multiple recipients of list ORACLE-L Objet: RE: Privileges needed for truncate Unfortunately drop any table. -Original Message- Sent: Thursday, September 19, 2002 10:24 AM To: Multiple recipients of list

Re: Privileges needed for truncate

2002-09-19 Thread Ruth Gramolini
To truncate you need delete privileges. Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, September 19, 2002 10:23 AM Hi I need to create a user/role that among other stuff must be able to truncate a table. I can't figure out which