db_owner role

db_owner role

• Neil_D_Jones

  Hello.
  
  would this be better done and/or executed using dbo rights How is the dbo different than the db_owner role, in this type of situation. I am going through a very similar issue.
  
  Best Regards,
  
  Dirce
  
  
  

• carrera7

  Thanks.

  Could you describe the "Grant the appropriate permission to the role that you need" in as little more detail as to what has to be done

  Thanks for the help

  
  

• Thrix

  I don’t know the complete list of permissions you will need for your work to be done, so you would have to go the iterative way to get your work done, here are the steps to complete:
  
  -Create a db Role in the Database msdb (as you want to administer the alerts and things related to the SQL Agent)
  -Assign users to this role that should do the administrative work.
  -Assign the appropiate permissions to that db role (where the users are currently in) Put in the execute right for that procedure you get an error for.
  
  HTH, Jens SUessmeyer.
  
  ---
  http://www.sqlserver2005.de
  ---

  
  

• moemoe

  There is no specific db_role for job administation, but you can create one. Grant the appropiate permission to the role that you need and assign the user to that role. You sure can also only grant the specific user the rights for that, but the next time you want another user to do the job you will have to repeat your work for that.
  
  

  HTH, jens Suessmeyer.
  
  ---
  http://www.sqlserver2005.de
  ---

  
  
• db_owner role