Re: Developers Access in PROD

From: BP Margolin (bpmargo@attglobal.net)
Date: 05/31/02 

From: "BP Margolin" <bpmargo@attglobal.net>
Date: Thu, 30 May 2002 22:26:56 -0400

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: Group properies help..
    ... business network main pc (XP Pro x64). ... The share permissions are one thing - but the more important permissions are ... In Win2K Pro I can give access right to certain users (Developers). ...
    (microsoft.public.windowsxp.security_admin)
  • Re: IIS access permissions
    ... "Jim Toth" wrote in message ... > directory permissions for an ASP.NET web application that is to be worked ... VS.NET server components on your web server. ... Developers group will be created. ...
    (microsoft.public.inetserver.iis)
  • Permissions for database
    ... This is a common problem. ... For each database, create a developer role and a Readonly ... The developers can be ... should have select permissions and execute permissions. ...
    (microsoft.public.sqlserver.security)
  • Re: Group properies help..
    ... how do you set the NTFS permission on a file. ... The share permissions are one thing - but the more important permissions ... In Win2K Pro I can give access right to certain users (Developers). ... that will allow me to set the access rights to this drive on x64. ...
    (microsoft.public.windowsxp.security_admin)
  • Re: security templates
    ... You could use Group Policy/Windows settings/security settings - registry on ... OU with a couple test computers in it to make permissions are exactly what ... all of the developers are located in the eastern ...
    (microsoft.public.windows.server.security)