Re: Allow Developer to Design tables, but not be owner?

Using SQL 2000, there is no easy solution at hand. In some situations, the
'sensitive' data tables are put into a different database for reasons like
this one. Different security needs.

Using SQL 2005, you may benefit from investigations schemas. See 'Using
Schemas' in Books Online.

--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc

Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous


"Scott Townsend" <scooter@xxxxxxxxxxxxxxxx> wrote in message
news:Ojh7b3q0GHA.4772@xxxxxxxxxxxxxxxxxxxxxxx
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: CREATE AGGREGATE failed because type Concatenate does not conform to UDAGG specification due to
    ... Go to the Database tab and click on the browse button next to the connection string. ... In the New Database Reference dialog, enter the details for the database where you want to deploy the assembly and create the user defined aggregate. ... I'm trying to do some CLR integration with sql server 2005. ...
    (microsoft.public.sqlserver.programming)
  • CREATE AGGREGATE failed because type Concatenate does not conform to UDAGG specification due to meth
    ... Now register the assembly and the aggregate in the SQL Server database you want ... I'm trying to do some CLR integration with sql server 2005. ...
    (microsoft.public.sqlserver.programming)
  • Re: dbdebunk Quote of Week comment
    ... > a lot of really bad SQL programmers. ... But SQL does not have a pointer data type or the ... > being told to design a database. ... But why is little Cindy Lou Who employee ...
    (comp.databases.theory)
  • Re: DBMS and lisp, etc.
    ... Naively implemented with SQL, again for 10 ... (1 query for the initial orders, 1 query for each order for its ... soon as you upgrade to the SQL database. ... (eq (order-customer orderA) ...
    (comp.lang.lisp)
  • Re: dbdebunk Quote of Week comment
    ... > a lot of really bad SQL programmers. ... a surrogate key should support the primary key. ... But SQL does not have a pointer data type or the ... > being told to design a database. ...
    (comp.databases.theory)
Loading