Post reply

how to restrict user access of tables in sql server 2005

  • May 16, 2008 at 4:12 am

    #190616

    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

    #816331

    Hi

    This link may be usefull.

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

    Thanks

    jaypee

  • May 16, 2008 at 4:24 am

    #816333

    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

    #821672

    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