PADMANABHAN RAGHAVAN
SSC Journeyman
Points: 82
More actions
July 1, 2005 at 12:33 am
#88001
Hi,
Can someone help me with this?I need to create a readonly user in Sqlserver database.
how do i go about it?I have no idea on how to
create a readonly user.
regards,
padmanabhan.R
Chris Hedgate
One Orange Chip
Points: 25041
July 1, 2005 at 12:51 am
#570239
Create a user in the database with no permissions other than the right to access the database. Then add that user to the db_datareader fixed database role.
--Chris Hedgate http://www.hedgate.net/Contributor to the Best of SQL Server Central volumesArticles: http://www.sqlservercentral.com/columnists/chedgate/
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply