Create a role in the database.. under Security->Roles
Add users the the role while creating it or once its created in the
roles General Properties
Add the role just created to the procedure's permissions
Grant execute permissions for that role for that procedure.. and see if
you have the same problem with the users that are trying to execute
that proc who have that particular role.
Vern Rabe wrote:
In SQL Server 2005, we have users that are not in the db_owner role. We have
granted permission to create stored procedures in the dbo schema, but once
created, the user doesn't have permission to GRANT EXEC permission. How can
that be accomplished?
Re: Help pls: Not allow users access to tables, stored procedures ..."Dan Guzman" wrote: ...Dynamic SQL effectively breaks the ownership chain. ... etc) is performed via stored procedures....correct permission for select permission on the tables. ... (microsoft.public.sqlserver.security)
Re: Help pls: Not allow users access to tables, stored procedures ... Are all the objects in the same database?... If not, cross-database chaining... etc) is performed via stored procedures....correct permission for select permission on the tables. ... (microsoft.public.sqlserver.security)
Re: Remote SP debugging from VS 2003: error ... "Cannot debug stored procedures because the SQL Server database is not setup ... correctly or user does not have permission to execute master.sp_sdidebug." ... I have configured DCOM on the remote sql server according tothe MSDN ... I have added SQLDebugger account to default permissions in dcom. ... (microsoft.public.sqlserver.connect)
REmote Debugging from Visual Std. 2003 env ... "Cannot debug stored procedures because the SQL Server database is not setup ... correctly or user does not have permission to execute master.sp_sdidebug." ... I have configured DCOM on the remote sql server according tothe MSDN ... I have added SQLDebugger account to default permissions in dcom. ... (microsoft.public.sqlserver.clients)
Re: Remote SP debugging from VS 2003: error ... "Cannot debug stored procedures because the SQL Server database is not setup ... correctly or user does not have permission to execute master.sp_sdidebug." ... I have configured DCOM on the remote sql server according tothe MSDN ... I have added SQLDebugger account to default permissions in dcom. ... (microsoft.public.sqlserver.security)
