Re: SQL User permissions


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: MS Access DAO -> ADO.NET Migration
    ... William Vaughn ... Microsoft MVP ... Hitchhiker's Guide to Visual Studio and SQL Server ... My migration app works building a SSCE database file with imported data ...
    (microsoft.public.dotnet.framework.adonet)
  • 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)
  • 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)