Cannot see non-dbo-owned objects in Enterprise Manager

[PTW]

Hi Everyone,

One of our programmers cannot see the objects that she owns when she uses Enterprise Manager.

I have set her up with a SQL account and she does have permission to create Views. She also has Datareader and Datawriter roles on the database. However, on the list of Views in Enterprise Manager she can only see the ones owned by dbo. She cannot see the ones that she created.

When I log in as sa, I can see all of the Voews including the ones that she has created.

Can anyone tell me what I have done wrong? I need her to be able to Create, Modify, and Delete her own Views. Thanks!

 

[hmckillop]

You could add her to dd_ddladmin and this will allow here to maintain and alter existing views without being able to change data.


"I'm living so far beyond my income that we may almost be said to be living apart

 

[SQLSister]

Frankly it is best from a maintenance standpoint for all objects to belong to dbo. Then you don't have problems of changing ownership when people leave and you don't have the problems of security becasue the view and the sp are owned by different people. What if you need this person to make a change to someone else's object becasue that person is out sick? Anything other than dbo for ownership is a bad idea in my opinion.

Questions about posting. See faq183-874