SQL Server Role Security

From: Nancy Kafer (nkafer_at_18004preneed.com)
Date: 12/31/03 

Date: Wed, 31 Dec 2003 09:54:16 -0600

I have a group of developers that I want to allow permissions to
create/alter table structures in a particular database. I don't want to give
them rights to alter the database itself just rights to alter the structures
inside the database. I run the following command in the query analyzer
connected to the development database:

GRANT CREATE TABLE TO DevAdmin

DevAdmin is a Windows 2K Group containing the developers. We are running SQL
Server 2000.

When I have one of the devlopers open Enterprise Manager and check the
permissions on a table in the development database the design option is
still grayed out. How can I accomplish allowing the devlopers to change the
structure of tables, views, etc...without giving them db_owner rights and
without allowing them to alter the database itself?

Thanks.

Nancy

Relevant Pages

  • Re: db_denydatawriter
    ... perhaps this also gives read write access on the database to this user? ... Resrictive permissions overrides in its own level. ... However, if she has sysadmin right, then she'll be able to modify that data. ... Is it possible she has some admin rights which override DenyWriter (though ...
    (microsoft.public.sqlserver.security)
  • Re: Issue: LDB Not Being Created
    ... I would totally agree that it is a rights issue (and was convinced it ... I open the database and the LDB gets created. ... file create permissions, then all other users of the network would be able ... However if one user opens up the file does not have correct permissions to ...
    (comp.databases.ms-access)
  • Re: SQL Server 2005 Stored Procedure security annoyances
    ... stored proecedure on a database wide level? ... GRANT EXECUTE ON SCHEMA::MySchema TO MyRole ... I am sure I will forget some SP's and probably forget to set the rights ... permissions because not all stored procedures are equal. ...
    (microsoft.public.sqlserver.security)
  • 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: Grant admin rights to user temporarily
    ... The issue is that I have a database with empty tables, as it should, when I ... > rights to give themself rights... ... > Consequently the code, acting with the permissions of your user, can't give ... > the case of an action query, to run the query, even if they are otherwise ...
    (microsoft.public.access.security)