: Jack van
Zanen/nlzanen1/External/MEY/NL)
Sent by: Subject: RE: Privileges needed for
truncate
[EMAIL PROTECTED
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
: [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
-
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
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
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
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
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
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
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
: 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
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
12 matches
Mail list logo