Home
Topics
Microsoft SQL Server Administration
SQL Server Security
SQL Server id permission to create and modify tables

SQL Server id permission to create and modify tables

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?

Requires Free Membership to View

Login

By submitting your registration information to SearchSQLServer.com you agree to receive email communications from TechTarget and TechTarget partners. We encourage you to read our Privacy Policy which contains important disclosures about how we collect and use your registration and other information. If you reside outside of the United States, by submitting this registration information you consent to having your personal data transferred to and processed in the United States. Your use of SearchSQLServer.com is governed by our Terms of Use. You may contact us at [email protected].

If you're on SQL Server 2005, consider creating a schema and giving the user permissions on the schema instead of the whole database.

More News and Tutorials

Articles

Related glossary terms

Terms for Whatis.com - the technology online dictionary

This was first published in December 2007

Join the conversationComment

Share

Comments

Results

Contribute to the conversation

All fields are required. Comments will appear at the bottom of the article.

Back to top

More from Related TechTarget Sites

Business Analytics
Data Center
Data Management
Data Management UK
Oracle
Content Management
Windows Server

Business Analytics
- Geospatial data could transform the way government does business
  
  With the help of geospatial data and visualization techniques, government can make decisions for constituents that are smarter and have more impact.
- Mobile BI apps move up the corporate priority list
  
  The growing use of tablet PCs and smartphones is spurring demand for mobile business intelligence capabilities from end users. Are you ready?
- BI competency center brings coordination -- but with complications
  
  Managed effectively, business intelligence competency centers help align BI projects with corporate goals. But they also can become BI bottlenecks.
Data Center
- Two data center hosting companies, one building and Hurricane Sandy
  
  Updated: Two data center hosting companies make their home in one building in Manhattan, which flooded Sunday.
- FAQ: Make the most of VM resources with strategic allocation
  
  Optimizing the allocation of VM resources will help make the most of data center virtualization.
- How much do you know about 'big data' infrastructure?
  
  Take this quiz to see if your data center's 'big data' infrastructure will hold up.
Data Management
- IBM executives, customers share 'big data' tips at Information on Demand
  
  An IBM VP and a user from Sprint took to the stage at the vendor's Information on Demand conference to offer advice on how to make sense of big data.
- Zornes connects the dots between big data and master data management
  
  Consultant Aaron Zornes believes that MDM and big data were made for one another.
- IT pros reveal benefits, drawbacks of data virtualization software
  
  Attendees at Composite Software's Data Virtualization Day conference had plenty of advice for companies considering a data virtualization project.
DataManagement UK
- Big data roundtable webcast: gaining value from big data
  
  Roundtable discussion on business value of big data, chaired by Brian McKenna, Editor, SearchDataManagementUK, and featuring Mike Ferguson, Roxane Edjlali (Gartner), Joshua LeCure (GlaxoSmithKline).
- 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 for 2012.
- 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 at UK companies, including dirty data problems.
Oracle
- Oracle E-Business Suite R12 upgrade aided by checklists
  
  A pre- and post-upgrade checklist will go a long way toward ensuring a successful Oracle E-Business Suite R12 upgrade.
- How to copy Oracle Database 9i to a new server
  
  Expert Brian Peasland explains to one puzzled reader how to copy Oracle Database 9i from one production server to another.
- The finer points of Oracle applications and Oracle Business Accelerators
  
  DAZ consulting group's Deborah Arnold takes some time out of OpenWorld to talk about Oracle Business Accelerators and Oracle applications.
Content Management
- Personal privacy an issue in enterprise social plans at multinationals
  
  Different cultures view personal privacy matters differently. Multinationals wanting improved collaboration must plan enterprise social networks adoption carefully.
- Three questions bring focus to document imaging, management planning
  
  Asking three questions about organizational needs helps map out an effective document management and imaging process, says IT consultant Steve Weissman.
- World of Warcraft offers organizational learning lessons
  
  John Seely Brown opened up KMWorld by describing a new process of organizational learning that enterprises should embrace to remain competitive in a new era.
Windows Server
- FAQ: Clustering in Windows Server 2012
  
  Clustering in Windows went through major change with the Windows Server 2012 release. Here's what's new and how to take advantage of the improvements.
- Admin quiz: Test your Microsoft Group Policy knowledge
  
  Think you're an expert in Microsoft Group Policy? Test your knowledge with our quiz.
- Q&A;: Windows user group founder talks Windows Server 2012 features
  
  An independent IT expert goes over his favorite features in Windows Server 2012 and explains how they will make life easier for IT pros.

All Rights Reserved,Copyright 2005 - 2012, TechTarget