Home Forums SQL Server 2005 Administering Need to give Developer access to create stored procs RE: Need to give Developer access to create stored procs

  • You can grant the right to create procedures specifically.

    Would look like this:

    GRANT CREATE PROCEDURE TO bob;

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon