question

on the schema?

yes, if you want the user to be able to view all definitions within the schema: "VIEW DEFINITION granted at [the schema] scope allows the grantee to see all metadata for all objects that are contained in the specified schema unless the grantee is denied VIEW DEFINITION or CONTROL permissions for an individual entity in the schema" - http://technet.microsoft.com/en-us/library/ms175808(v=SQL.105).aspx GRANT syntax details - http://technet.microsoft.com/en-us/library/ms187940(v=sql.105).aspx

Im afraid that hasnt worked, when double clicking on the schema i can see new permission but none of the views allocated to the schema appear in graphical query designer

I've never used the graphical designer. I just took a peek and am trying to understand what you mean. * Can you see the views when you expand the 'Views' folder inside the database in SSMS? * Can you see the view definition when you right-click the view and select 'Design'? * Within the view designer, can you see the other views on the 'View' tab when you right-click the design surface and select 'Add Table...' * Are you opening the view designer some other way and trying to see the views from within the empty view designer (if so, how do you open the designer without going through the 'View' folder)? * Not view designer specific, can you right-click a view and 'Script View as...' -> 'Create To' -> 'New Query Editor Window'?

The user can see the views in ssms. They cannot see the views in the design GUI (ctrl N , crtl shift Q) then click on views tab. This tool is similar to the views designer but is just used for querying. Thank you for your continued support KenJ