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 3:38 am

    #929076

    Hi Abhijit,

    EXECUTE permission is already there. When I DENY VIEW DEFINITION permission it is giving the above error, otherwise not.

    Hi Gail,

    Those sps are not accessing any system tables.

    Thanks,

    Shaiju C.K.

    _____________________________________________
    One ounce of practice is more important than tonnes of dreams