SQL 2005 Execute permissions
-
I am not understanding the permission problem I am having and what the Schema object is for. My Database has Stored procedures owned by a user, let say corp. If I look at the database there is a Schema also called corp owned by corp. corp has all roles except db_DenyDatareader and db_DenyDatawriter and is not aliased to dbo. Now it has been my understanding that since the user corp owns the Stored procedure it should have execute rights to it. The problem is when my application opens and tries to execute a stored procedure I get denied for lack of Execute permission. If I log into the database using enterprise manager (2005 version) with the corp login I can get into the database but I can not see any of the Stored procedures that the corp user owns. I can not figure out this issue any ideas are greatly appreciated. Thanks