Link to home
Create AccountLog in
Avatar of michalek19
michalek19Flag 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
Avatar of Pawan Kumar
Pawan Kumar
Flag of India image

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.
Avatar of 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
Avatar of 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.
ASKER CERTIFIED SOLUTION
Avatar of Pawan Kumar
Pawan Kumar
Flag of India image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
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?