should I give dbo permissions to NT AUTHORITY\NETWORK SERVICE?
I wouldn't directly say it is insecure to give dbo permissions to that account but it is definitely more secure to have the application run under an account only it can use and apply permissions accordingly.