troubleshooting Question

Giving a Programmer full access to a specific database (and no access to others) including object explorer

Avatar of lbjamison
lbjamisonFlag for United States of America asked on
Microsoft SQL Server
6 Comments1 Solution267 ViewsLast Modified:
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.
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 6 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 6 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros