Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Oracle Tables and Privileges
Message
De
16/07/2002 09:13:44
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Titre:
Oracle Tables and Privileges
Divers
Thread ID:
00679054
Message ID:
00679054
Vues:
51
Hi,

I told the Data Base Administrator of one of my clients that I needed to delete all records of a given Oracle table (in VFP that would be a ZAP). I had two ways of doing that: thru a DELETE From or a TRUNCATE. I asked him to give me the privileges to perform TRUNCATEs in that Oracle table (it should be faster). He replied me that he couldn't do it because if he gave me that privilege, it would imply that:

(a) I could perform TRUNCATEs in any other table of that database and

(b) giving me the TRUNCATE privilege I would be able to DROP any other table in that database too.

Is it correct what he's saying?

TIA

Fernando
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform