Re: app role has exec permission but still can't execute sp
From: Dejan Sarka (dejan_please_reply_to_newsgroups.sarka@reproms.si)
Date: 11/07/02
- Next message: Joe: "change owner from former dba"
- Previous message: Adi Cohn: "Re: app role has exec permission but still can't execute sp"
- In reply to: Diederik: "Re: app role has exec permission but still can't execute sp"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
From: "Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@reproms.si> Date: Thu, 7 Nov 2002 15:57:43 +0100
Yes,
I can't see any dynamic SQL or a call to an extend SP from the code. What
might happen is problem with ownership. You should use an explicit two-part
name when creating and calling the procedure. Also, sp_ prefix is reserved
for system SPs, try to rename the procedure (I am not going into details
here, but there might be a procedure with the same name in master db, and
SQL Server tries to run that one). Next that comes through my mind is the
fact that an application role is a member of the Public role. So, if you
denied permissions to the Public role, you can't execute the procedure. Hope
that something here will help you.
-- Dejan Sarka, SQL Server MVP FAQ from Neil & others at: http://www.sqlserverfaq.com Please reply only to the newsgroups. PASS - the definitive, global community for SQL Server professionals - http://www.sqlpass.org
- Next message: Joe: "change owner from former dba"
- Previous message: Adi Cohn: "Re: app role has exec permission but still can't execute sp"
- In reply to: Diederik: "Re: app role has exec permission but still can't execute sp"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
