Re: whats is wrong here????

Just because a user has been added to a DB does not mean that they have
permissions to do anything. Either grant them EXEC permission on that proc
or add them to a role that has EXEC permission in the proc.

--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau


"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



.