Re: Newbie to security

From: Sue Hoegemeier (Sue_H_at_nomail.please)
Date: 11/12/03

  • Next message: kris: "hide server" 
    Date: Wed, 12 Nov 2003 15:43:16 -0700

    Use sp_grantlogin to grant the login
    Use sp_grantdbaccess to grant access to the database.
    Use grant select on <whatever table> to <that user>
    And that's it at a high level...with a lot of other
    considerations left out if you dig a bit more - for example
    the public role and how that would come into play.
    It's not necessarily a trivial task to secure a server and
    databases when you are new to security. You may want to
    review the security topics in books online and also review
    the following documents:
    Microsoft SQL Server 2000 SP3 Security Features and Best
    Practices
    http://www.microsoft.com/technet/prodtechnol/sql/maintain/security/sp3sec/default.asp
    10 Steps to Help Secure SQL Server 2000
    http://www.microsoft.com/sql/techinfo/administration/2000/security/securingsqlserver.asp
    SQL Server Resource Kit - Implementing Security
    http://www.microsoft.com/technet/prodtechnol/sql/reskit/sql2000/part3/c1061.asp
    SQL Server Operations Guide - Security Administration
    http://www.microsoft.com/technet/prodtechnol/sql/maintain/operate/opsguide/sqlops3.asp

    -Sue

    On Wed, 12 Nov 2003 10:17:27 -0800, "barmanvarn"
    <anonymous@discussions.microsoft.com> wrote:

    >Ok, I need to create a login for a user. This user only
    >needs to be able to do a select on one table in one
    >database. I want this user to access only this table.
    >How exactly do I do this?
    >
    >thanks in advance

  • Next message: kris: "hide server"

    Relevant Pages

    • Re: SQL or Access DB
      ... As far as encryption goes though... ... with Sql Server you can use SQL DMO and encrypt your stored procedures ... installation - Security was absolutely critical and in most instances, ... > then we create a nice gui around this database and sell it to automotive ...
      (microsoft.public.dotnet.languages.vb)
    • Re: Cryptography in SQL Server 2000
      ... SQL Server 2000 Out-of-the-Box database security solution. ... database protection and privacy software is an industry-proven ...
      (microsoft.public.sqlserver.security)
    • Re: No db access after publishing web site
      ... GRANT UPDATE TO ... If I detach and attach this database on a different PC (according that PC ... Cannot open database "pago" requested by the login. ... Are you detaching/attaching the SQL Server Express database correctly ...
      (microsoft.public.dotnet.framework.aspnet)
    • Re: SQL or Access DB
      ... i am aware of the security modell of SQL server (we do use SQL server ... an end user,,, there is not reall alternative as a worgroup Access database ... MSDE and SQL express are all free ...
      (microsoft.public.dotnet.languages.vb)
    • Re: Cryptography in SQL Server 2000
      ... A company is vulnerable when its security ... > database encryption solution with protected key-management software ... > tested by the SQL Server Test Lab. ...
      (microsoft.public.sqlserver.security)