permision in database

• a.e.ghorbani

  Right there with Babe

  Points: 741

  More actions

  January 8, 2011 at 12:41 am

  #243446

  i have 2000 table in database and 10 person have access to all structur and data and edition in tables.

  i want to restrict the access of edit structure of tables to 2 person?

  and only 2 person have access to edit structure of tables.

  what do i do ?

  please advise me ?

• Adiga

  One Orange Chip

  Points: 27284

  More actions

  January 8, 2011 at 3:33 am

  #1271037

  Grant ALTER TABLE permission to the 2 and deny it to the rest.

  Pradeep Adiga
  Blog: sqldbadiaries.com
  Twitter: @pradeepadiga