user permission dbo

Posted on 2009-04-29
Last Modified: 2012-05-06

When you alias a login to dbo for a database then the user has also permissions to create additional datafiles for that database or to expand the database.

Is it possible to give a user permission so that he can create tables, views, sp's, ...
But not the permission to adjust the database itself ? For me this is more a serverwide permission than a database permission only.


Question by:Geert Bettens
    LVL 12

    Expert Comment

    Then don't give the user dbo privileges.
    Simply run "grant select, update, delete, insert, create on schema::[dbo];" (minus quotes).
    Have a beutiful day & God bless,
    Chris Musasizi.
    LVL 12

    Accepted Solution

    Here's the command you should execute after creating the mapping on the account on to the that database.
    This will definitely grant the user database permissions.
    It's worth it to avoid server level roles like sysadmin. This will elevate the user to do anything on the instance.
    Grant the user the default (public) role.
    All the best.

    grant select, insert, update, delete, execute, control on schema::[dbo] to [dblogin];

    Open in new window


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    6 Surprising Benefits of Threat Intelligence

    All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

    There are some very powerful Data Management Views (DMV's) introduced with SQL 2005. The two in particular that we are going to discuss are sys.dm_db_index_usage_stats and sys.dm_db_index_operational_stats.   Recently, I was involved in a discu…
    I am showing a way to read/import the excel data in table using SQL server 2005... Suppose there is an Excel file "Book1" at location "C:\temp" with column "First Name" and "Last Name". Now to import this Excel data into the table, we will use…
    Hi everyone! This is Experts Exchange customer support.  This quick video will show you how to change your primary email address.  If you have any questions, then please Write a Comment below!
    In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

    760 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    12 Experts available now in Live!

    Get 1:1 Help Now