michalek19
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
• bulk updates
• stats monitoring
• insert
• VIEW SERVER STATE
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
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
I can't have SA permission. I can have DBO access with roles.Yes, dbo is dbowner but dbowner can't grant VIEW SERVER STATE as this permission is server based and not database based.
Does DBO = DB_Owner?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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?
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?
If you already closed this question why do you still have doubts on this similar question: https://www.experts-exchange.com/questions/29068598/SQL-script-to-generate-new-database-and-add-account-and-apply-proper-permission.html?anchor=a42371094¬ificationFollowed=200363343&anchorAnswerId=42371094#a42371094 ?
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.