--
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Eric Ward" <EricWard@discussions.microsoft.com> wrote in message
news:74243249-0388-410B-A306-9248A1A60C79@microsoft.com...
> How do I give a roles access to execute a SP?
>
> Let me clarify:
> I know that I can create a role and then go give that role Execute
> permission to all the SP.
>
> I wondering if there is an easier way?
>
>
Re: Execute Persmission denied on object sp_OACreate ... > SQL Server is creating a job behind the scenes. ... > permissions.... > SA account password and gaining access to the database.... >>> How can get a user permissions to execute these stored procedures ... (microsoft.public.sqlserver.security)
Re: SSIS - OLE DB Command - how to retrieve query results ??? ... my side according to your process, and I managed to execute the task. ...Data Destination: <My SQL Server 2005 Instance>.TestDB ...OLE DB Command: ... (microsoft.public.sqlserver.dts)
Re: 3 Simple Security SQL Statements ... Kalen Delaney, SQL Server MVP... window and execute.... Builds a list of text commands.... EXEC sp_addrolemember 'WebUsersRole', 'WebUser' ... (microsoft.public.sqlserver.security)
Re: DTS Error EXCEPTION_ACCESS_VIOLATION ... >>We have some DTS jobs that runs every night called via a ... >>Package... If this is no help, then please describe how you execute the package, ... DTS - http://www.sqldts.com PASS - the definitive, global community for SQL Server professionals... (microsoft.public.sqlserver.dts)
Re: Problem with the Legacy ASP files and the Sql Server Express ... It looks like it is not going to be an easy job getting it to work on the SQL Server 2005 and Express:(. ... 'Then you can execute the command and then retrieve the ID ... I am 100% sure this code works against any version of SQL Server, as long as the connection is OK and the SP has two parameters @varCompany as Input and @Return_Value as Output. ... I do not think your problem is due to difference of SQL Server2000 and SQL Server2005, unless your stored procedure has some thing that only works in SQL Server2000, not SQL Server 2005. ... (microsoft.public.dotnet.framework.aspnet)
