exec proc premission

From: "paulixml" <paulixml@xxxxxxxxxxx>
Date: Thu, 27 Apr 2006 21:15:55 -0700

Hi

I created a user called development in sql server 2005 and make it a member
of datareader,datewriter and ddladmin role. now I created a proc under that
development account. however when I try to exec that proc, its give a
permission denied error. How come? it was able to create proc, but not
exec, its there something I have to do?

thanks

.

Prev by Date: sysxlogins table with <NULL> entries
Next by Date: Payroll Security
Previous by thread: sysxlogins table with <NULL> entries
Next by thread: Re: exec proc premission
Index(es):
- Date
- Thread

Relevant Pages

Re: SqlDataAdapter1.SelectCommand.CommandType= CommandType.StoredProcedure
... >> kann man beim EXEC PROC keine Parameter beifügen. ... > da das TDS Protokoll das intern unterscheiden kann. ... > nach der Ausführung ungültig werden. ...
(microsoft.public.de.german.entwickler.dotnet.datenbank)
Re: using nexted procs
... So I have a cataloged proc 'FJS.PDSE.PROC' that looks like this: ... //IEFRDER DD DUMMY //SYSUOUT DD SYSOUT=* ... //FFND05 EXEC DLIBATCH,DLIPGM=FFND05,DLIPSB=FFUNDGO ... Our goal was that when testing we would execute the production proc and override the DD names to the names of test files. ...
(bit.listserv.ibm-main)
typo error...
... First Proc should be p1 and not p3 ... > exec p1 ... >> Over night we take a copy of various live SQL databases onto another SQL ... >> I connect to the live databases using linked servers. ...
(microsoft.public.sqlserver.programming)
Re: Strangeness in PROC-land
... //STEP1 EXEC PGM=IEFBR14 ... It complains about the second PEND because you can not nest PROCs inside ... instream data inside a PROC. ... But the JCL error is on the second PEND ...
(bit.listserv.ibm-main)
Re: SQL Variable USE.
... I then exec the proc like so: ... SQL server will decide where to put it on ... > it from the database level settings. ...
(microsoft.public.sqlserver.programming)