Re: sql server role (read only accnt for a user)
From: Tom Moreau (tom_at_dont.spam.me.cips.ca)
Date: 09/19/05
- Next message: mwastesson_at_gmail.com: "Is there a way to find out which login who created a login?"
- Previous message: Uri Dimant: "Re: sql server role (read only accnt for a user)"
- In reply to: pleo: "sql server role (read only accnt for a user)"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Mon, 19 Sep 2005 07:09:22 -0400
Proceed as follows:
1. Add the login to SQL Server, using sp_grantlogin.
2. For the database in question, add the user, using sp_grantdbaccess.
3. Add the user to the db_datareader role, using sp_addrolemember.
-- Tom ---------------------------------------------------- Thomas A. Moreau, BSc, PhD, MCSE, MCDBA SQL Server MVP Columnist, SQL Server Professional Toronto, ON Canada www.pinpub.com . "pleo" <pleo_el@hotmail.com> wrote in message news:OAM4$fQvFHA.3452@TK2MSFTNGP14.phx.gbl... A user just wants to connect current sql database for query. No need to modify anything or admin. What sql server accnt role should I create for this user? Can I do that and please provide the steps. Thanks a lot
- Next message: mwastesson_at_gmail.com: "Is there a way to find out which login who created a login?"
- Previous message: Uri Dimant: "Re: sql server role (read only accnt for a user)"
- In reply to: pleo: "sql server role (read only accnt for a user)"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
