• You can give permissions on specific objects, so what you can do is just give the user permissions to do select and delete on those tables. If you don’t give permission on other objects and don’t add those users to roles with other permissions, your user will only be able to run the select and delete statement on those tables. You can use the GUI to grant the permissions or use GRANT statement (you can read about both ways in

    Books On Line)

    Adi

    --------------------------------------------------------------
    To know how to ask questions and increase the chances of getting asnwers:
    http://www.sqlservercentral.com/articles/Best+Practices/61537/

    For better answers on performance questions, click on the following...
    http://www.sqlservercentral.com/articles/SQLServerCentral/66909/