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

schema to text file 7
ADP and dbo prefixes 1
Apple Script in Outlook 365 Mac keystrokes blocked on M1 mac 0
SQL Schema permissions AD group not recognized by Access 2007 ADP 1
Modifying Table through Access in different Schema on SQL 2005 0
Access 2003 adp file in Access 2007 3
Changing dbo in a ADP 1
ADP in A2007 Runtime: Traditional binding of form to stored procedure taking no parameters no longer 0

Top