oracle 中给用户A授予创建视图的权限,可以创建视图。但将此权限放入角色中,则不能创建视图

2020-05-23 时尚 88阅读
You must have been explicitly granted the SELECT, INSERT, UPDATE, or DELETE object privileges on all base objects underlying the view or the SELECT ANY TABLE, INSERT ANY TABLE, UPDATE ANY TABLE, or DELETE ANY TABLE system privileges. You may not have obtained these privileges through roles.
不能通过roles获得的权限来创建别的schema下的view
声明:你问我答网所有作品(图文、音视频)均由用户自行上传分享,仅供网友学习交流。若您的权利被侵害,请联系fangmu6661024@163.com