且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

授予对视图的 SELECT 权限,但不授予对基础对象的权限

更新时间:2022-04-02 21:32:58

拥有视图的用户是否也拥有底层表?如果不是,则表的所有者需要使用 WITH GRANT OPTION 授予视图所有者权限.如果同一个用户同时拥有表和视图,那么授予视图权限就足够了.

Does the same user who owns the view also own the underlying tables? If not, the owner of the tables needs to grant the view owner permission WITH GRANT OPTION. If the same user owns both the tables and the view, then granting permission on the view should be sufficient.