Allow Developer to Design tables, but not be owner?

I have some developers that I need to be able to do anything to the Database
except look in a few tables in that database.

I have a DenyHR Role that denies Access to the HR Tables, though if I give
them dbOwner that seems to defeat the purpose.

They need to still create and design existing tables. How can I accomplish
this?

Thank you,
Scott<-


.

Relevant Pages

  • Re: MV Keys
    ... is implemented by developers using an interface to a dbms. ... want dbms tool designers to suggest they will be making design ... a database would not be production software without having a means ...
    (comp.databases.theory)
  • Re: New to DB Development
    ... web design with a database isn't ... > command and the use of the Windows scheduling service will accomplish ...
    (microsoft.public.inetserver.asp.db)
  • Re: Datebase needed for tracking of drugs for a fire department!
    ... including for MS Access database development. ... There are good developers, don't get me wrong, but one has to ... Excel makes you think in math calculations. ... Shelf life of the drug could be loaded once and then access ...
    (microsoft.public.access.tablesdbdesign)
  • Re: WHY
    ... I've been working a lot longer than that LoL ... re-creating the same spreadsheet, ... > I'm sure the database admins do all the work at, say, Boeing and Airbus, ... > Or perhaps you meant implicitly to restrict your remarks to developers. ...
    (microsoft.public.excel)
  • Re: Combining tables - UNUSUAL REQUEST
    ... It's not an unusual request at all. ... developers to realize that their original table design needs some refinement ... in order to accommodate the needs of the growing database application. ... That's how database developers get "experience." ...
    (microsoft.public.access.tablesdbdesign)