Post reply

protecting a table

  • July 24, 2008 at 6:04 pm

    #191524

    hi can some one tell me

    how can we give protection to a table.

    if we dont want any of the users to add/remove columns for our table, how can we do so??

    Thanks in advance

  • July 24, 2008 at 10:40 pm

    #848196

    Don't give the users rights to do these tasks. By default, users have no rights to tables. If you do not use db_owner or sysadmin rights as a general rule, you should be OK. Only give users SELECT, INSERT, UPDATE, DELETE rights as needed.

  • July 25, 2008 at 2:41 am

    #848254

    set the permission for the user.

    :crazy: DENY ALTER dbo.TableName:: TO USER

    Abhijit - http://abhijitmore.wordpress.com

  • July 25, 2008 at 9:57 am

    #848529

    I hope that our SQL Server Security Workbench [/url] will tell you how to do this.

    Best wishes,
    Phil Factor

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply