permissions issues

• Angelindiego

  SSCertifiable

  Points: 6048

  More actions

  June 28, 2005 at 10:45 am

  #167698

  Good morning, me again!!!  OK, here is my issue for today: I have to be very strict about sysadmin privilages on my db's.  I have an instance here today, where I need to give one gentleman sysadmin privilages on ONE db that he accesses so that he can run extended sp's on that db to write to files.  Under his user name, he has public privilages on all the db's he has access to.  If I put him in a sysadmin role, he gets those rights to ALL db's.  Is there any way of giving him sysadmin rights to just ONE database?????  I am struggling with this one!!  Thanks for your help!!!

  ---

  Thank you!!,

  Angelindiego
  

• Ninja's_RGR'us

  SSC Guru

  Points: 294069

  More actions

  June 28, 2005 at 11:31 am

  #569070

  Please do not cross-post.

  Finish the thread here : http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=146&messageid=194872