What SQL account will give me access to create following tasks?

What SQL account will give me access to create?

•      bulk updates
•      stats monitoring
•      insert
•      VIEW SERVER STATE
michalek19Asked:
Who is Participating?
 
Pawan KumarDatabase ExpertCommented:
Does DBO = DB_Owner?
Yes

But you need some Server level permission also for this kind of stuff.
0
 
Pawan KumarDatabase ExpertCommented:
Please read this from Microsoft-

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.
0
 
michalek19Author Commented:
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
0
Introducing Cloud Class® training courses

Tech changes fast. You can learn faster. That’s why we’re bringing professional training courses to Experts Exchange. With a subscription, you can access all the Cloud Class® courses to expand your education, prep for certifications, and get top-notch instructions.

 
Vitor MontalvãoMSSQL Senior EngineerCommented:
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.
0
 
michalek19Author Commented:
What server level permission do I need? Is it DB_Owner?
So, on SQL database level I need to DBO and on server level I need to DB_Owner.

Can you please explain how I can grant server level access on SQL server?
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.