Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Permission problem with SQL sp
I have created a stored procedure in SQL Server. I can execute this SP from Sql Server Management Studio fine. But when I try to execute this SP from VFP, I get the following error:
***********
"Connectivity error: [Microsoft][ODBC SQL Server Driver][SQL Server]EXECUTE permission denied on object 'mytest', database 'MyDatabase', owner 'dbo'."
***********
I can query any table in SQL Server with SQL Pass Through. And I can call the System Stored Procedures but I can't call a Stored Procedure that I created.
What do I have to do to call a SP that I created from VFP?
Thanks,
Jerry
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