Re: SQL User permissions

I am sorry about being unclear. I have not done this already. I am trying
to determine if I can setup a user that when they log into SQL Server
Management Studio that they only see their database and nothing else. I have
done as you have said below and gone to the database and given this account
dbo permissions for this database. They are not a member of any of the
builtin security roles and I have not created any new ones. When I log in as
this user using Management Studio they can see all databases and permissions,
etc. I only want them to be able to see their database and only make changes
to their database. I don't know if that even can be done but that is my goal.



"Qi Ding [MSFT]" wrote:


Hello, ace95hockey

Thank you for using newsgroup!

Based on your description, I am not very clear about the process of your
configuration. Can you tell me how you set another administrator account to
let it only access the certain database?

Generally we can perform the following steps to set account permissions in
SQL Server 2005.

1.Open Microsoft SQL Server Management Studio.
2.In the left panel, click databases, select the database you want. For
example, we select ¡°tempdb¡±.
3.Right click mouse on ¡°tempdb¡± then select ¡°properties¡±.
4.In the dialog box appeared select ¡°permissions¡±
5.In the right panel you can see ¡°users and roles¡±, add a user you want.
6.In the ¡°explicit permissions for guest¡± panel we can set the user¡¯s
permissions.

For more details I searched the information below and hope to help.

Title:Assigning SQL Server Database Roles
http://msdn2.microsoft.com/en-us/library/ms915731.aspx

Title:Database-Level Roles
http://msdn2.microsoft.com/en-us/library/ms189121.aspx

Title:Adding a Member to a SQL Server Database Role
http://msdn2.microsoft.com/zh-cn/library/aa905200(SQL.80).aspx

Title:DatabaseRole Members
http://msdn2.microsoft.com/it-it/library/microsoft.sqlserver.management.smo.
databaserole_members.aspx

Regards!

QiDing

Microsoft Online Support
Microsoft Global Technical Support Center

Get Secure! - www.microsoft.com/security
====================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.




--------------------
| Thread-Topic: SQL User permissions
| thread-index: AcdV32L0PZnUxZK1S9aDTeSm3/avNw==
| X-WBNR-Posting-Host: 130.113.45.40
| From: =?Utf-8?B?YWNlOTVob2NrZXk=?= <ace95hockey@xxxxxxxxxxxxxx>
| References: <F738DAC9-CD0B-468A-B845-DEE2183417E6@xxxxxxxxxxxxx>
<#bwfAtcVHHA.2212@xxxxxxxxxxxxxxxxxxxx>
| Subject: Re: SQL User permissions
| Date: Wed, 21 Feb 2007 09:40:32 -0800
| Lines: 31
| Message-ID: <8FEE914A-F008-4135-97B7-31379DA3B05B@xxxxxxxxxxxxx>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.2757
| Newsgroups: microsoft.public.sqlserver.security
| Path: TK2MSFTNGHUB02.phx.gbl
| Xref: TK2MSFTNGHUB02.phx.gbl microsoft.public.sqlserver.security:784
| NNTP-Posting-Host: tk2msftsbfm01.phx.gbl 10.40.244.148
| X-Tomcat-NG: microsoft.public.sqlserver.security
|
| I didn't assign it to any server roles. I just double checked that it
didn't
| get assisgned by default and it is not assigned to anything.
|
| "Uri Dimant" wrote:
|
| > Did you add this login to sysadmin server role? If you did , remove it
and
| > grant access to the db you would want
| >
| >
| >
| >
| >
| > "ace95hockey" <ace95hockey@xxxxxxxxxxxxxx> wrote in message
| > news:F738DAC9-CD0B-468A-B845-DEE2183417E6@xxxxxxxxxxxxxxxx
| > >I have SQL 2005 Standard installed in Mixed Mode
| > >
| > > I am new to SQL and I want to setup a database off my SQL server that
| > > another administrator will have access too. I created a new SQL
account
| > > and
| > > gave it dbo permissions to only the database I created but when I log
in
| > > to
| > > test this user has full access to see all databases. I would like to
| > > change
| > > this so this user can only see their database and nothing else.
Please
| > > let
| > > me know if you can point me in the right direction.
| > >
| > >
| >
| >
| >
|


.

Relevant Pages

  • Re: Backup still not working
    ... So you may try to rebuild the RSM database if the ... > rename the existing files in this folder to a .old file extension, ... > this time unchecks "First Storage Group" under Microsoft Exchange Server. ... > 1) Open SQL Server Enterprise Manager. ...
    (microsoft.public.windows.server.sbs)
  • Re: cant move sharepoint by the instructions. AGAIN
    ... Monitoring database to another location. ... If you installed the SQL Server or the SQL Server Management Tools, ... Microsoft CSS Online Newsgroup Support ... This newsgroup only focuses on SBS technical issues. ...
    (microsoft.public.windows.server.sbs)
  • Re: Database Connectivity
    ... But, MSDE has been know to work very reliably in small user LANS, ... > just a simple step to attach the tables from MSDE to SQL Server. ... database, or pay for an "industrial-strength" version of it when there ... Don't like Microsoft?, sounds like a personal problem to me. ...
    (comp.lang.python)
  • 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: MS Access DAO -> ADO.NET Migration
    ... Microsoft chose to change the name from SQL Server Everywhere ... It's a fully relational database that supports a subset of the ... DAO has methods and properties that are Access ...
    (microsoft.public.dotnet.framework.adonet)