本文介绍了Serviceaccount没有bigquery.jobs.create权限的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
授予服务帐户的权限为所有者"和"bigquery admin".
Permission given to service account is "owner" and "bigquery admin".
$bigQuery = new BigQueryClient([
'projectId' => 'project-xxx',
]);
$query = "SELECT * FROM `project-xxxx.analytics_xxx.events_xxx` where event_name='first_open' LIMIT 100";
$jobConfig = $bigQuery->query($query);
$queryResults = $bigQuery->runQuery($jobConfig);
print_r($queryResults);
当我尝试执行上述代码时,它显示以下错误:
when I try to execute above code its show below error:
{ "error":
{ "errors": [ { "domain": "global", "reason": "accessDenied",
"message": "Access Denied: Project project-xxxx: The user
projectbigquery@project-xxxx.iam.gserviceaccount.com does not have
bigquery.jobs.create permission in project project-xxxx." } ],
}}
推荐答案
创建具有与先前帐户相同权限的新服务帐户后,该帐户便可以正常工作.我不知道以前的帐户有什么问题.可能是服务帐户出现了一些问题.
After creating new service account with same permission as per previous account, its working. I don't know whats wrong with previous account. May be some issue from service account.
这篇关于Serviceaccount没有bigquery.jobs.create权限的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!