how to assign below permission to user who is already having db_owner permissions. like
1.deploy SSIS package
2. able to schedule jobs
3. able to reorg tables databases
according to my knowledge
for deploy SSIS package i have given roles in MSDB to that user- DTsltduser, DTSadmin and DTSoperator.
for schdule jobs given SQL agent roles SQL agent reader, SQL Agent user SQL agent operator
for reorg tables databases given sysadmin rights.
It's working fine. but i want to restrict from creating a new database. how ?