Re: SSMS 2008: Object Explorer Details
  Home FAQ Contact Sign in
microsoft.public.sqlserver.tools only
 
Advanced search
POPULAR GROUPS

more...

microsoft ... sqlserver.tools Profile…
 Up
Re: SSMS 2008: Object Explorer Details         


Date: Dec 24, 2008 08:38

It was after testing with that and not having an issue that I figured
out my problem was really with the objects that were in schemas other
than dbo.

All of the schemas were owned by the user id that created them rather
than being owned by dbo. I changed them to dbo and was able to grant
the permissions needed. I can now see the objects in SSMS without a
problem.

Thank you for your help and for including your script.
Toni

*** Sent via Developersdex http://www.developersdex.com ***
1 Comment
Re: SSMS 2008: Object Explorer Details         


Author: Erland Sommarskog
Date: Dec 24, 2008 15:28

Toni (teibner@allinadotcom) writes:
> It was after testing with that and not having an issue that I figured
> out my problem was really with the objects that were in schemas other
> than dbo.
>
> All of the schemas were owned by the user id that created them rather
> than being owned by dbo. I changed them to dbo and was able to grant
> the permissions needed. I can now see the objects in SSMS without a
> problem.
>
> Thank you for your help and for including your script.

Glad to hear that it worked out.

...and for the future, recall to include such details that objects are
different schemas with different owners. It's easier to help when I
have the full knowledge of what is going on.

--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
Show full article (1.01Kb)
no comments