db_datareader allow alter permissions

• ajsnyman

  Right there with Babe

  Points: 732

  More actions

  January 5, 2012 at 12:54 pm

  #1429309

  Thank you Perry and Gail, your explanations helps a lot.

  Unfortunately I'm not sole admin of the DB and will need to investigate who gave the permissions and why.

  Ignorance is not always bliss 😛

  Kind regards

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  January 5, 2012 at 2:04 pm

  #1429357

  Perry Whittle (1/5/2012)

  ---

  Granting CONTROL at the schema level is quite brave IMHO 🙂

  I could use a few other words than 'brave' I think 🙂

  Gail Shaw
  Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
  SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

  We walk in the dark places no others will enter
  We stand on the bridge and no one may pass

• Perry Whittle

  SSC Guru

  Points: 234013

  More actions

  January 5, 2012 at 5:54 pm

  #1429419

  GilaMonster (1/5/2012)

  ---

  Perry Whittle (1/5/2012)

  ---

  Granting CONTROL at the schema level is quite brave IMHO 🙂

  I could use a few other words than 'brave' I think 🙂

  😀

  -----------------------------------------------------------------------------------------------------------

  "Ya can't make an omelette without breaking just a few eggs" 😉