What definition do I need to set ?...

Main Page | Report this Page

Computers Forum Index » Computer - Databases - MS SQL Server » What definition do I need to set ?...

Page 1 of 1

What definition do I need to set ?...

Author

Message

David Greenberg...

Posted: Sun Sep 13, 2009 4:07 pm

Guest

Hi
We are using Sql 2008.
I havce a developer who needs to make changes to a table definition,
column types etc.
What kind of server role and permissions do I need to give her on the
databases and tables ?
Thank you
David

Erland Sommarskog...

Posted: Sun Sep 13, 2009 4:07 pm

Guest

David Greenberg (davidgr at (no spam) iba.org.il) writes:

Quote:

We are using Sql 2008.
I havce a developer who needs to make changes to a table definition,
column types etc.
What kind of server role and permissions do I need to give her on the
databases and tables ?

She needs ALTER permission on the table.

More generally, if you need to know what permissions to use a certain
command, a quick way to find the answer is to look in the Permissions
section of the topic for the command in Books Online.

--
Erland Sommarskog, SQL Server MVP, esquel at (no spam) sommarskog.se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

Page 1 of 1

All times are GMT The time now is Fri Mar 19, 2010 8:59 am Computers Forum Index