Re: whats is wrong here????

To add to Tom's response, you can grant a role (or user) execute permissions on all objects on a schema with a single GRANT. For example:

GRANT EXECUTE ON SCHEMA::dbo TO WebRole;

Note that it is generally best to grant permissions at the schema level only when you don't need to be more granular. If a principal needs access to some objects but not others, individual object GRANTs are the best approach, IMHO. This is in contrast to a GRANT at the schema level and DENYs on individual procs that take precedence over granted permissions.


--
Hope this helps.

Dan Guzman
SQL Server MVP
http://weblogs.sqlteam.com/dang/

"alecarnero" <alecarnero@xxxxxxxxxx> wrote in message news:e6uZ0U7VIHA.2000@xxxxxxxxxxxxxxxxxxxxxxx
I have a sql 2005 database i can look the tables but not execute pro, i have regsiter the users iwan and iusr in the database



Microsoft OLE DB Provider for ODBC Drivers erro '80040e09'

[Microsoft][ODBC SQL Server Driver][SQL Server]EXECUTE permission denied on object 'res_vent', database 'centerplan', schema 'dbo'.

/resplanejados.asp, line 21



.

Relevant Pages

  • Re: Create table in schema
    ... SQL Server MVP ... "Tom Moreau" wrote: ... Every time I try to grant control to the dds_pco_role, ... EXEC sys.sp_executesql N'CREATE SCHEMA AUTHORIZATION ...
    (microsoft.public.sqlserver.security)
  • Re: Yukon schemas
    ... ALTER to the schema. ... you have to grant create permission to perform the action ... data and to create and alter stored procedures and views that they owned. ...
    (microsoft.public.sqlserver.security)
  • Re: Create table in schema
    ... I also got that when I ran grant alter on schema. ... A_Role and want to assign all the permissions to the role. ...
    (microsoft.public.sqlserver.security)
  • Re: Create table in schema
    ... SQL Server MVP ... Every time I try to grant control to the dds_pco_role, ... Cannot grant, deny, or revoke permissions to sa, dbo, entity owner, ... I also got that when I ran grant alter on schema. ...
    (microsoft.public.sqlserver.security)
  • Re: Create table in schema
    ... SQL Server MVP ... I also got that when I ran grant alter on schema. ... A_Role and want to assign all the permissions to the role. ...
    (microsoft.public.sqlserver.security)