CODEWITHSUNDEEP
sqlsql-serverresource-governor
Yasin Bilir
Yasin Bilir

Reputation: 304

SQL Resource Governor without master database permissions

We have a production SQL database on amazon cloud and we don't have any write permissions in the master database.

In order to create a Resource Pool for resource governor, we need to create a classifier function in the master database to get details for the user sessions. So, due to the permission denies, we can't create a function in the master database.

Is there any other way to create a resource pool without having permissions in the master database ?

Thanks in advance.

Upvotes: 0

Views: 74

Answers (1)

Meyssam Toluie
Meyssam Toluie

Reputation: 1081

If you have really NO permission, so defiantly can not create any object in master database.

Upvotes: 0

Related Questions