database restrict

• rajnidas.y

  SSC-Addicted

  Points: 431

  More actions

  January 23, 2014 at 12:21 am

  #287547

  hi everyone,

  how to restrict alter statement dml,ddl database in sql server 2012

  thanks

  Rajnidas

• Koen Verbeeck

  SSC Guru

  Points: 259155

  More actions

  January 23, 2014 at 12:35 am

  #1682650

  By giving (GRANT/DENY or adding them to roles) the appropriate permissions to people?

  For example, you can add people to the DDL_ADMIN role if you want them to execute DDL.

  If you add people for example only to the db_reader role, they can read data but they cannot change it or execute DDL statements.

  Need an answer? No, you need a question
  My blog at https://sqlkover.com.
  MCSE Business Intelligence - Microsoft Data Platform MVP