Using non-dbo schema in 2007 ADP

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?
 
A

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

Similar Threads

dbo schema problem and permissions 1
ADP and dbo prefixes 1
SQL Schema permissions AD group not recognized by Access 2007 ADP 1
Access 2003 adp file in Access 2007 3
Database connection issue using SQL schema user account 3
(dbo) after SQL items in database 1
ADP - Report Recordsource Permission Error - View ... Does Not Exist 6
Access 2007, SQL 2000 3

Top