Home Forums SQL Server 2005 SQL Server 2005 Security Object does not exist error is getting if VIEW DEFINITION denied RE: Object does not exist error is getting if VIEW DEFINITION denied

  • January 19, 2009 at 12:31 am

    #929043

    C.K.Shaiju (1/19/2009)

    I have denied VIEW DEFINITION permission of all the objects of a database for a particular user. But he is getting an error like "Object does not exist or you do not have permission" while he is trying to execute some stored procedures. This error is coming ONLY for few stored procedures and rest everything is working properly. If I grant the View Definition permission to those objects it will work properly.

    What could be the issue? Kindly help.

    GRANT EXECUTE Permission on object this will resolve your problem.

    Abhijit - http://abhijitmore.wordpress.com