SQLServer Login as sa vs dbo

[ansz5]

I need to connect to db and grant rights of only db owner so as to prevent any security breach but at the same time , my application needs to run certain jobs,, for which i need sa rights. Please suggest a solution. how to go abt it.. I need to write a script to ask - to whom do we want to assign sa rights and dbo rights, using parameters as user and role.

[iburyak]

I didn't test it but you might try to create a stored proc to run jobs which accepts necessary parameters. Stored proc must be created by SA and grant execute rights to this proc to DBO users.

Hope it works.

[ansz5]

which is the role with minimum permissions including a one to execute jobs.