SQL Server id permission to create and modify tables

by Greg Low

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

This Article Covers

Security

Looking for something else?

+ Show More

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

Pro+

Features

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

E-Handbook

Developments in SQL Server BI point to focus on self-service, users
E-Handbook

Understanding SQL Server virtualization
E-Handbook

Understanding Microsoft SQL Server business intelligence options

Related Q&A; from Greg Low

Is it possible to find disabled indexes in SQL Server 2000?

If you're working with SQL Server 2000 and trying to find a disabled index, here's something you should know. continue reading

Query to find SQL Server database names created by users

Find how to query in SQL Server to get all database names created by users. continue reading

Problem attaching stored procedure and SQL Server trigger

Learn why using the sp_OACreate stored procedure with a SQL Server 2005 trigger, is likely to result in a permissions problem. continue reading

Have a question for an expert?

Please add a title for your question

Get answers from your peers on your most technical SQL Server challenges.

Meet all of our SQL Server experts

View all SQL Server questions and answers

Search BusinessAnalytics

Big data definition fractures technology market

Technology vendors have tried to develop their own big data definition, which has helped rip apart the market for analytics tools.

News recap: Data mining techniques help stop fraud, new IBM offerings

In this news recap, federal agents use data mining techniques to stop fraud and IBM releases new self-service offerings.

How to prep your big data architecture for better analytics

Collecting big data sets doesn't mean you're ready to do big data analytics. Read these tips on setting the stage with big data ...

Search DataCenter

Stop fixing every equipment failure in the data center

Lacking human interaction isn't a bad thing when it comes to data center equipment. A fragile IT approach minimizes humans and ...

PowerShell tutorial for Windows server admins

A lot has changed with PowerShell 4.0. Whether you're new to the CLI or want new tricks in your server administrating bag, now's ...

Hyperconvergence emerges as a data center building block

Hyperconvergence is succeeding converged infrastructure technology for data centers that are fast, efficient and more hands-off ...

Search DataManagement

VoltDB 4.0 boosts query speeds, enables on-the-fly cluster scaling

The latest version of VoltDB's NewSQL database expands on its initial operational processing focus, enhancing query capabilities ...

Former shadow IT worker helps bring analytics data into the light

Ryan Fenner worked in a shadow IT unit at Union Bank for years. Now he's helping lead an IT effort to better manage BI data ...

Podcast report covers recent Enterprise Data World event

This week's Talking Data podcast recaps Enterprise Data World and a mother lode of data quality information.

Search DataManagementUK

Video: IBM uses analytics at Wimbledon to track players' performance

IBM provides analytics and statistics for Wimbledon.com. Players also benefit from analytics. Andy Murray always picks up his ...

2012 training courses: BI, data management, data warehousing

Find out where to hone your business intelligence, data management and data warehouse skills with this list of training courses ...

Poor data quality: what is dirty data costing UK organisations?

Poor data quality can have serious financial consequences for businesses. Read about the current state of data quality management...

Search Oracle

Lydall says no to Oracle's forced updates, upgrades with Rimini Street

Rimini Street helped Lydall get away from forced updates and upgrade between two versions of Oracle EBS not supported by Oracle.

Oracle Database hosting quiz: In-house, hosted or cloud systems?

Take this 10-question quiz to find out if your Oracle databases should be run on-premises, in a hosted environment or in the ...

Oracle's one-size-fits-all big data management strategy doesn't fit

After Team Oracle's victory in the America's Cup, it's clear that the company is hot on big data -- and not just the technology ...

Search ContentManagement

Five key questions about social media monitoring and analytics

For companies that want to derive business value from social media monitoring and analytics, our expert has answers.

SharePoint 2013 analytics provides insight into public-facing sites

For a more useful view on who's visiting your public-facing sites, try connecting SharePoint 2013 to a Web analytics engine.

Collaboration software: It’s not about the tools

The success of a collaboration software tool starts long before its purchase. First design a collaboration strategy that delivers...

Search WindowsServer

Microsoft pushes Azure, leaves data centers in the dark

Microsoft’s enterprise vision revolves around cloud computing, so where do users of products like System Center Configuration ...

Patch Tuesday brings security updates for IE, Office, SharePoint

In this month's Patch Tuesday Microsoft addresses critical remote code execution vulnerabilities in Office, SharePoint and an IE ...

Microsoft serves up an Azure feast but IT pros aren't eating it up

Microsoft made it abundantly clear that Azure will be the engine that drives all mission critical initiatives for the foreseeable...

Looking for something else?

Dig deeper on SQL Server Security

E-Handbook

E-Handbook

E-Handbook

Related Q&A; from Greg Low

Have a question for an expert?

0 comments

E-Mail

Username / Password

Password

Forgot Password?

Your password has been sent to: