May 16, 2008 at 4:12 am
Hi ,
Would appreciate if someone could let me know how we can restrict access such as read-only/full access to the tables in the database
Thanks
May 16, 2008 at 4:21 am
Hi
This link may be usefull.
http://www.sqlservercentral.com/Forums/Topic490100-359-1.aspx
Thanks
jaypee
May 16, 2008 at 4:24 am
You can use DCL (Data Control Language) to ristrict the user access on the tables of the database.
For more information on DCL please use the Microsoft Books online...
Basit Ali Farooq
MCITP Database Administrator
Microsoft Certified Professional Developer (Web Applications)
Microsoft Certified Database Administrator
Microsoft Certified Systems Engineer
Microsoft Certified Systems Administrator
CIW Security Analyst
Cisco Certified Network Associate
May 29, 2008 at 4:57 am
Steps which I followed to restrict a group (windows authentication) accessing a database:
1.Created a group for Windows authentication (Administrative tools-> computer management-> add groups (searched in the local network and added 3 users including mine))
2.In SSMS, I connected using ‘sa’ login
a.opened Security Folder
b.-> Right clicked Login (Created a new login for the group created )
c.-> Right clicked the new login -> User mapping-> Restricted access for a single database as denydatawriter
When I login using windows authentication, am unable to edit any tables as expected, whereas the other user are able to access the tables and modify.
Note: Sql server 2005 server is local machine of mine
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply