Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Connect VFP to SQL Server w/o ODBC
Message
De
28/11/2000 11:49:16
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Divers
Thread ID:
00445800
Message ID:
00446219
Vues:
14
The owner is 'dbo'. As explained below, I try to acces (via VFP) with
user name 'pomuser' and not 'dbo'. Why 'pomuser' give all rights?
Thank you again.

>Who owns the table? The owner has all rights to a table even if it is >specified otherwise.

>>Thank you! Everything works fine.
>>But I got another problem with SQL-Server permissions.
>>
>>My SQL-Server table (pom_punches) has permissions setted like below:
>>-User name is 'pomuser' and only the Insert permission is granted.
>>When I do connection to my SQL table in VFP
>>(using SqlStringConnect function with UID='pomuser';PWD='xxxx'),
>>the result is success (I get an handle). But I can also do a
>>SQLEXEC(lnhandle, "select * from pom_punches", "mycursor")
>>or a SQLEXEC(lnhandle, "delete from pom_punches") with success.
>>Why the Select always works (permission is revoked)?
>>
>>Thank you again for your help.
Marc Levesque
La Prairie, Quebec (CANADA)
marc.levesque@videotron.ca
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform