Q

SQL Server id permission to create and modify tables

A SQL Server application that needs user permission to create and modify tables in SQL Server 2005 may be handled best via a schema.

An application needs permission to create tables on the fly. I don't want to give the id db_owner. How do I give this id permission to create and modify tables in a database?
If you're on SQL Server 2005, consider creating a schema and giving the user permissions on the schema instead of the whole database.
This was first published in December 2007

Dig deeper on SQL Server Security

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchBusinessAnalytics

SearchDataCenter

SearchDataManagement

SearchAWS

SearchOracle

SearchContentManagement

SearchWindowsServer

Close