Hello Sergey,
Thanks for your respond. I've been learning from your post all this time, but I think this is the first time you answer my post (can't complain, I'm not too active in the UT anyway --- but I think that'll change soon!)
>Any user that has System Administartor role granted can view or access any >DB.
I see. Well, I have to go with encryption then. Do you have any alternatives so that the user cannot view the data? Better yet: the user cannot view the data structure.
>You can do that in Enterprise Manager (EM) by right clicking on DB and
>selecting All Tasks - Generate Sql Script. You can also do it >programmaticaly with SQL-DMO using Script method of different objects. The
>ExecuteImmediate method of SQL Server object can be used to to run the
>script on the target server.
But how can I call the script from my VFP apps?
TIA,
Willianto
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement