Assignin Permissions in Microsoft SQL Server Studio Express

Posted on 2007-08-06
Medium Priority
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
  • 3
LVL 43

Expert Comment

by:Eugene Z
ID: 19639054
did you install sql server managment studio for Express?
if not get it from microsoft.com
in the SSIM gui you will see  Server->DB->security (or grant permissions on object level)
LVL 43

Accepted Solution

Eugene Z earned 2000 total points
ID: 19639061
LVL 43

Expert Comment

by:Eugene Z
ID: 19639075
one more:
Managing SQL Server Express with SQL Server 2005 Management Studio Express Edition

Featured Post

Vote for the Most Valuable Expert

It’s time to recognize experts that go above and beyond with helpful solutions and engagement on site. Choose from the top experts in the Hall of Fame or on the right rail of your favorite topic page. Look for the blue “Nominate” button on their profile to vote.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In part one, we reviewed the prerequisites required for installing SQL Server vNext. In this part we will explore how to install Microsoft's SQL Server on Ubuntu 16.04.
One of the most important things in an application is the query performance. This article intends to give you good tips to improve the performance of your queries.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.
Suggested Courses

850 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