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.
michalek19
ASKER
I can't have SA permission. I can have DBO access with roles.
Does DBO = DB_Owner?
I can have only DBO access, what roles will give me that additional access I need to
• bulk updates
• stats monitoring
• insert
• VIEW SERVER STATE
Vitor Montalvão
I can't have SA permission. I can have DBO access with roles.
Does DBO = DB_Owner?
Yes, dbo is dbowner but dbowner can't grant VIEW SERVER STATE as this permission is server based and not database based.
https://docs.microsoft.com/en-us/sql/t-sql/statements/grant-server-permissions-transact-sql
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.