Author: Erland SommarskogErland 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
|