I can't have SA permission. I can have DBO access with roles.
Does DBO = DB_Owner?
© 1996-2023 Experts Exchange, LLC. All rights reserved. Covered by US Patent
Looks like you need a DB_Owner/Sysadmin permission. These permissions really powerful. If this does not work you can create a login and provide each separate permission to it. like below-
GRANT ADMINISTER BULK OPERATIONS TO [yourserverlogin]
GRANT INSERT on SCHEMA::dbo to yourlogin.