Error message displays when attempting to expand Procedures or Views nodes
-
I've created a schema for a group login on our SQL Server 2005 64 bit Enterprise Edition server. A member of the group created tables, stored procedures, views and functions under the schema (which is owned by the group login) on a database in which the login has DataReader, DataWriter and DDLAdmin permissions. When the user expands the Tables node for the database, all tables are displayed, those under their schema as well as others. All is well when the user expands the Programmability/Functions node - they can see functions created under the group's schema as well as those created under dbo. The problem occurs when the user attempts to expand the Programmability/Stored Procedures node or the Views node. In each case, a Dialog box comes up that contains the following error messages - 'Failed to retrieve data for the request. A severe error occurred on the current command. the results, if any, should be discarded.' The group has control permission on the stored procedures as well as on the functions and views.
From my point of view, SQL Server seems inconsistent. The user can see the functions, for which they have control permission, but cannot see the stored procedures, for which they also have control permissions. I'm obviously missing something but for the life of me, I can't figure out what it is. Does anyone have any hints or clues that I can follow up? My head is getting sore from banging it on my desktop!
-
Did you solve the problem?
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply