Read Only Access to Stored Procedures

From: Colette (Colette_at_discussions.microsoft.com)
Date: 07/28/05

  • Next message: Mike Epprecht (SQL MVP): "RE: Read Only Access to Stored Procedures" 
    Date: Thu, 28 Jul 2005 06:59:08 -0700

    We do not allow anyone except DBA's the DBO access permission in our
    organization for the "production" environment. The programmers get
    DataReader/DataWriter access in production, however, they are wanting
    read-only access to the stored procedures.

    Does anyone know of a why to give them READ ONLY access to stored procedures?

    Thanks for your help.

    Colette

  • Next message: Mike Epprecht (SQL MVP): "RE: Read Only Access to Stored Procedures"

    Relevant Pages

    • Re: PL/SQL or SQL in the middle tier?
      ... SQL code in production. ... stored procedures and stored functions to debug the issue. ... whatever was the myth of the day. ...
      (comp.databases.oracle.server)
    • Re: PL/SQL or SQL in the middle tier?
      ... SQL code in production. ... launched by our DBA's to have software engineers move the PL/SQL out ... stored procedures and stored functions to debug the issue. ...
      (comp.databases.oracle.server)
    • PL/SQL or SQL in the middle tier?
      ... SQL code in production. ... stored procedures and stored functions to debug the issue. ...
      (comp.databases.oracle.server)
    • Re: Quote from student, after teaching Pick
      ... that VB6 is almost avant garde among many VB programmers who still plough ... Modern languages build in structures that allow developers to tighten ... it's hack hack hack and people go to production. ... Software quality is at an all time low - this isn't just my opinion, ...
      (comp.databases.pick)
    • Re: rant -> your religion gets bashed here ... [long]
      ... I think more programmers own their means of production than do ... >> workers in any other industry, owing to the fact that a personal ... > connected to a corporate network. ...
      (comp.programming)