Assignin Permissions in Microsoft SQL Server Studio Express

Posted on 2007-08-06
Last Modified: 2012-06-22
Using Windows Server 2003 and Microsoft SQL Server Studio Express I am trying to figure out how to give a specific user group admin rights to specific tables or dbs.  I can not seem to find a way to do this.
Question by:gordonmann
    LVL 42

    Expert Comment

    did you install sql server managment studio for Express?
    if not get it from
    in the SSIM gui you will see  Server->DB->security (or grant permissions on object level)
    LVL 42

    Accepted Solution

    LVL 42

    Expert Comment

    one more:
    Managing SQL Server Express with SQL Server 2005 Management Studio Express Edition

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Setting up a Microsoft WSUS update system is free relatively speaking if you have hard disk space and processor capacity.   However, WSUS can be a blessing and a curse. For example, there is nothing worse than approving updates and they just have…
    Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
    This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
    Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.

    761 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

    13 Experts available now in Live!

    Get 1:1 Help Now