Re: Permissions question...

From: Juraj Rojko (juraj_at_rojko.cz)
Date: 01/11/05 

Date: Tue, 11 Jan 2005 23:37:58 +0100

Use

GRANT CREATE PROCEDURE TO SomeOne

Juraj

"Brett Davis" wrote:
> Hello...
>
> I have a role in a SQL Server 2000 database called "Power Developer",
> within this role I want to allow the developer the ability to change
> stored procedures but not table schema. I have looked at the ddl_admin
> database role but that looks like that will give the developer the ability
> to change all database objects. Is there a way where I can allow the
> developer to change stored procedures but not table schema?
>
> Please advise...
>
> Thank you,
>
> Brett
>
>

Relevant Pages

  • Re: Stored procedure update permission
    ... Within our development database: ... Each developer has their own sql login and each developer has rights to ... stored procedures, ...
    (microsoft.public.sqlserver.server)
  • Re: Stored procedure update permission
    ... SQL Server MVP ... >> Each developer has their own sql login and each developer has rights to ... >> that it will connect to the development database server using their ... >> stored procedures, ...
    (microsoft.public.sqlserver.server)
  • Re: Recommend an Application Development/Report Writing Tool?
    ... > I'm an experienced Access developer who appreciates the many wonderful ... > abilities that Access has as a front end development tool on an Oracle ... > management system (a very poorly done one, in my opinion, but one I am ... > some data manipulation ability. ...
    (comp.databases.oracle.tools)
  • Recommend an Application Development/Report Writing Tool?
    ... I'm an experienced Access developer who appreciates the many wonderful abilities that Access has as a front end development tool on an Oracle database. ... I'm looking for something that will let me easily connect to my data and use subforms/subreports, the ability to bind data to forms/reports and will allow me to escape the "enslavement" of having to run around to different installs and making sure a proper ODBC DSN is set up. ...
    (comp.databases.oracle.tools)
  • RE: Remote Assistance problem
    ... I wish that I, as a developer, had the ability (or the ... Please feel free to contact the MSDN Managed Newsgroup feedback alias ... happy to open up a support call using one of your incidents.. ...
    (microsoft.public.platformsdk.security)