I'm trying to set up a user who can have pretty much full access to a specific database. He could view all objects and have read-write-delete access. Most of what you would have as sa. The login is for development purposes.
I created a server user with the default database assigned.
I create the same user for the database and added him to the dbo_owner role and he can access the database fine in a query window.
The user cannot see the database or any other using Object Explorer in SSMS. I need for him to be able to use object explorer.
SQL Server 2008.