更新时间: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.