Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
MS SQL Server stored procedures
Message
 
À
30/07/1997 18:34:07
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Divers
Thread ID:
00042461
Message ID:
00042524
Vues:
37
> Referring to Scot's response -- I don't see DBO as being a bad thing, of > course I also don't let the users know what their SQL Server login id's > are!! Keeps 'em out of the back-end without going through my app. That is a good suggestion if you are on a closed system. If this is the case, I would recommend this as well. However, if you are not, aliasing can lead to some potential problems. Permissions can be by-passed and etc. At my shop, we allow our users to access the backend via other applications (mainly as ad-hoc GUI query tools and frequently as read only (s)) as well, so this may not work considering you can fire any TSQL command from something like VFP. I've found the most dangerous users are the ones who think they know what they are doing and want to correct "problems" they find (bg). Scot.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform