Could not find stored procedure â MSSQL Server - äëÿ íîâîãî ïîëüçîâàòåëÿ

14:11:2010 Ð³.

Ðàññìàòðèâàåòñÿ îøèáêà Could not find stored procedure â MSSQL Server.

Ñòîëêíóëñÿ ñ îøèáêîé ïðè ðàáîòå ñ õðàíèìûìè ïðîöåäóðàìè â MSSQL Server. Ïîòðàòèë ìèíóò 20 íà ýëåìåíòàðíóþ îøèáêó èç-çà êîòîðîé âûñêàêèâàëî îøèáêà "Could not find stored procedure".

Ñóòü:Åñòü êëèåíòñêîå ïðèëîæåíèå, êîòîðîå ñîåäèíÿåòñÿ ñ ÁÄ äëÿ âûïîëíåíèÿ îïðåäåëåííûõ äåéñòâèé. Äëÿ îáåñïå÷åíèÿ áåçîïàñíîñòè ñîçäàåòñÿ ïîëüçîâàòåëü â áàçå äàííûõ MSSQL, ó êîòîðîãî ïðàâà ïîëíîñòüþ îãðàíè÷åíû çà èñêëþ÷åíèåì âûïîëíåíèÿ ðÿäà õðàíèìûõ ïîöåäóð.

Ïðè âûïîëíåíèè âûçîâà õðàíèìîé ïðîöåäóðû èç ïðîãðàììû âûñêàêèâàåò èñêëþ÷èòåëüíàÿ ñèòóàöèÿ Could not find stored procedure.

Èçìåíåíèå ïðàâ, ïîìåùåíèå ïîëüçîâàòåëÿ â ãðóïïû íå ïîìîãàåò.

Âñå îêàçàëîñü ïðîùå - çàáûë ÿâíî óêàçàòü ïîëüçîâàòåëÿ, ê êîòîðîìó îòíîñèòñÿ õðàíèìàÿ ïðîöåäóðà.
Ê ïðèìåðó, õðàíèìóþ ïðîöåäóðó ñîçäàâàë ïîëüçîâàòåëü ÕÕÕ (àäìèí), à âîñïîëüçîâàòüñÿ äîëæåí YYY (ïîëüçîâàòåëü ñ îãðàíè÷åííûìè ïðàâàìè).

1) Äàåì ïîëüçîâàòåëþ YYY ïðàâà íà èñïîëíåíèå õðàíèìîé ïðîöåäóðû. Ìîæíî ëèáî ÷åðåç MSSQL Management Studio èëè ÷åðåç ïðÿìîé SQL-çàïðîñ:

GRANT EXECUTE ON Procedure_Name TO YYY

2) ×òîáû íå ïîëó÷èòü ñîîáùåíèå Could not find stored procedure ïðîñòî óêàçûâàåì ïîëíîå èìÿ õðàíèìîé ïðîöåäóðû:

EXEC [XXX].[Procedure_Name]

Âñå ðàáîòàåò. Æåëàþ íèêîìó íå íàñòóïàòü íà òàêèå ãðàáëè :)

Êîììåíòàðèè

0#1IvanMqy2017-09-14 01:13http://recoverperu.orgÖèòèðîâàòü

Îáíîâèòü ñïèñîê êîììåíòàðèåâ
RSS ëåíòà êîììåíòàðèåâ ýòîé çàïèñè.

Äîáàâèòü êîììåíòàðèé

« Ïóáëèêàöèÿ (publish) ASP.NET MVC v2 ïðîåêòà íà õîñòèíã (shared hosting)		Ïîëó÷èòü àâòîðèçèðîâàííîãî ïîëüçîâàòåëÿ ASP.NET Membership API »

← Ðàíüøå

Could not find stored procedure â MSSQL Server - äëÿ íîâîãî ïîëüçîâàòåëÿ

Êîììåíòàðèè

Äîáàâèòü êîììåíòàðèé

Ðóáðèêè

Ôîòîàëüáîì

Îáëàêî Òåãîâ