Using non-dbo schema in 2007 ADP


Jeff In Denver

When I try to edit views and sp in ADP that are not in the dbo schema, I get
an error that extended props are not allowed, or the object is not found. An
earlier post mentioned that non-dbo schema are not supported in older
versions of ADP, but wondered if 2007 / 2010 support this? If not, has a
workaround been found to not allow a subset of my users to have db_owner
permission to my database?

a a r o n _ k e m p f

you don't need to give everyone dbo permissions.. but you should leave
dbo as the owner for the lease amount of hassle

always specify dbo when you create objects, query objects, etc

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question