Re: creating objects with dbo creator without being a sys admin

From: Tom Moreau (tom@dont.spam.me.cips.ca)
Date: 03/03/03 

From: "Tom Moreau" <tom@dont.spam.me.cips.ca>
Date: Mon, 3 Mar 2003 14:39:01 -0500

You can add them to the db_ddlamin role in your database or grant them CREATE TABLE and CREATE VIEW permissions. 

-- 
Tom
---------------------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada   tom@cips.ca
www.pinnaclepublishing.com/sql
  "Megan" <Tracy_Megan_M@cat.com> wrote in message news:053801c2e1bb$b89e47f0$3001280a@phx.gbl...
  How can I have my customers create tables/views with a dbo 
  creator without giving them system admin rights?

Relevant Pages

  • Re: Detailed User Access Rights
    ... Sysadmin role members have full SQL Server permissions and OS permissions ... > 2) Now that my customers can create their own views etc, ... GRANT SELECT ON MyTableFunction TO CustomerUser ...
    (microsoft.public.sqlserver.security)
  • Re: Permissions to syslogins
    ... >>If you look at the permissions on syslogins you'll see it ... >>Jasper Smith (SQL Server MVP) ...
    (microsoft.public.sqlserver.security)
  • ADP, Application Role, and objects
    ... The above link is to an atricle on how to implement SQL Server Application ... After you connect with your ADP, fire a bit of code to set the ... third party tools to view the data on the same database. ... Scenario 1 - If I explicitly grant permissions on that object to the user ...
    (microsoft.public.access.adp.sqlserver)
  • Re: field level security question
    ... Vyas, MVP ... listBox control that gets data from a query of the sql server table. ... > recent change in requirement) I see the option to limit permissions right ... > utility opens except their is just no data. ...
    (microsoft.public.sqlserver.security)
  • RE: SQL 2008 - remote connection to the SSIS 2008 - Access denied
    ... SQL Server configures the appropriate rights during the installation process, ... then add users/groups and assign the appropriate permissions. ... user who created the package apply to the writer role. ... I checked DCOM MsDts component and my user rights for the Remote ...
    (microsoft.public.sqlserver.dts)
Loading