how to restrict user access of tables in sql server 2005

  • 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

  • Hi

    This link may be usefull.

    http://www.sqlservercentral.com/Forums/Topic490100-359-1.aspx

    Thanks

    jaypee

  • 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

  • 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