Re: Developers Access in PROD

From: Dinky (dinh.nguyen@dewr.gov.au)
Date: 05/31/02 

From: "Dinky" <dinh.nguyen@dewr.gov.au>
Date: Thu, 30 May 2002 20:48:49 -0700

BP Margolin,

To me the developer should have different kind of access
with users in PROD. If we give db_owner access to users,
also as developers, so both of them can create or drop an
object (table, SP etc...) in PROD, that it should not be
allowed in PROD, I think.

What I am thinking to do is somehow I want to give
developers browsing database structures only in PROD,
that I can prevent developers to "select" or DTS data to
another server. I wonder that there is any way we could
we do it in SQL Server that I know that we can do it in
another DBMSs.

D
>-----Original Message-----
>D,
>
>Typically, I'm willing to give application developers
db_owner permissions.
>
>One just needs to make sure that when testing an
application, that the
>developers log in to the database with a login that is
set to the
>permissions that one expects the login to have in
production.
>
>-------------------------------------------
>BP Margolin
>Please reply only to the newsgroups.
>When posting, inclusion of SQL (CREATE TABLE ...,
INSERT ..., etc.) which
>can be cut and pasted into Query Analyzer is appreciated.
>
>"Dinky" <dinh.nguyen@dewr.gov.au> wrote in message
>news:9b3401c20843$1f47deb0$b1e62ecf@tkmsftngxa04...
>> Folks,
>>
>> In your SQL Server shop, what kind of access has been
>> given to application developers? ie. db_reader,
>> db_owner, public etc...
>>
>> Thanks
>>
>> D
>
>
>.
>

Relevant Pages

  • Re: Developers Access in PROD
    ... I was assuming that you were talking about developers on a development box. ... The first concern is the sensitivity of the production data. ... > with users in PROD. ... >>> In your SQL Server shop, what kind of access has been ...
    (microsoft.public.sqlserver.security)
  • Re: Question on conversion to ADP
    ... parameters through VBA/pass-through queries. ... help/guidance coming from Microsoft for Access developers trying to ... Microsoft Access or SQL Server 2005: ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Can relational alegbra perform bulk operations?
    ... Unlike in most other fields that are so expensive to participate in, the ironic aspect in IT is that the "free software" developers usually mimic what the commercial ... Many people recoil in horrors regarding its apparent disregard for transactions and foreign key support, but to me this makes perfect sense: If it's not needed, then the developer should be able to choose to not need it. ... Basically, they used SQL Server as a reporting server, loading data from Oracle DSS. ... The users just needs to aggregate data upon filters of their choosing and generate reports; no updates except to dump the data and load new dataset from Oracle on a regular interval. ...
    (comp.databases.theory)
  • Re: How to create views with SQL-NS
    ... >> What programming language are you using for your Wizard? ... all of our developers have EM and QA. ... >>>creation within our security model that sits atop SQL Server. ...
    (microsoft.public.dotnet.framework.interop)
  • Re: Future of ADPs
    ... "Developers", that really started in Access and continued with Access ... Ms Access ADPs and SQL Server 2005 Express ... SQL Server 2005 Express and ASP.Net, ... Reports to design your reports. ...
    (microsoft.public.access.adp.sqlserver)