Using non-dbo schema in 2007 ADP

  • Thread starter Thread starter Jeff In Denver
  • Start date Start date
J

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?
 
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
 
Back
Top