英文:
Delete From table ; ORA-01031: insufficient privileges
问题
当我尝试使用以下请求删除一行：
DELETE gros_postes WHERE id_acteur_fk = '325'
我收到了这个错误：
ORA-01031: 权限不足
英文:
I have a table with only one field: id_acteur_fk.
When I want to delete a line by this request ;
DELETE gros_postes WHERE id_acteur_fk = '325'
I get this error :
> ORA-01031: insufficient privileges
答案1
得分: 1
It seems that gros_postes doesn't belong to you, and its owner didn't grant delete privilege to you (or public) so you aren't allowed to remove any rows. What to do? Contact the owner and ask for some more privileges.
As you aren't referencing it (gros_postes) with owner name, then it might be a (public) synonym, or maybe a (materialized?) view.
Provide some more info if what I wrote doesn't help. For example, what does
select * from all_objects where object_name = 'GROS_POSTES';
return?
英文:
It seems that gros_postes doesn't belong to you, and its owner didn't grant delete privilege to you (or public) so you aren't allowed to remove any rows. What to do? Contact the owner and ask for some more privileges.
As you aren't referencing it (gros_postes) with owner name, then it might be a (public) synonym, or maybe a (materialized?) view.
Provide some more info if what I wrote doesn't help. For example, what does
select * from all_objects where object_name = 'GROS_POSTES';
return?
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。
评论