Providing DBO

  • What is recommended providing a functional id db_owner privileges for creating an application / database role and explicitly providing execute permissions on stored procs?

    TIA

  • If you only want to add local roles or application roles and assign security, the db_securityadmin role would be a better bet.

    In saying that, I'm not keen on anyone outside of the dba team to change security - or anything on the production server - I prefer it all to be controlled within the team.

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply