Re: Newbie to security
From: barmanvarn (anonymous_at_discussions.microsoft.com)
Date: 11/13/03
- Next message: David Berman: "How do I grant security rights to batches of tables or stored procedures?"
- Previous message: Don Tipton: "SQLMAINT as non DBO user"
- In reply to: Sue Hoegemeier: "Re: Newbie to security"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Thu, 13 Nov 2003 10:40:17 -0800
Awesome, thanks
>-----Original Message-----
>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/sq
l2000/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: David Berman: "How do I grant security rights to batches of tables or stored procedures?"
- Previous message: Don Tipton: "SQLMAINT as non DBO user"
- In reply to: Sue Hoegemeier: "Re: Newbie to security"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
|
