Avatar of michalek19
michalek19
Flag for United States of America asked on

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
Microsoft SQL Server 2005SQL

Avatar of undefined
Last Comment
Vitor Montalvão

8/22/2022 - Mon
Pawan Kumar

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.
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.
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy
ASKER CERTIFIED SOLUTION
Pawan Kumar

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
michalek19

ASKER
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?
Vitor Montalvão