如何查询Oracle目录上的权限？ [英] How to query the permissions on an Oracle directory?

问题描述

我在all_directories中有一个目录，但是我需要找出与它相关联的权限，即已经授予的是什么？

I have a directory in all_directories, but I need to find out what permissions are associated with it, i.e. what has been granted on it?

推荐答案

这应该给你一个目录上授予的角色，用户和权限：

This should give you the roles, users and permissions granted on a directory:

SELECT * 
  FROM all_tab_privs 
 WHERE table_name = 'your_directory';  --> needs to be upper case

是的，它在all_TAB_privs视图中;-)一个更好的名称该视图将类似于ALL_OBJECT_PRIVS，因为它还包括PL / SQL对象及其执行权限。

And yes, it IS in the all_TAB_privs view ;-) A better name for that view would be something like "ALL_OBJECT_PRIVS", since it also includes PL/SQL objects and their execute permissions as well.

这篇关于如何查询Oracle目录上的权限？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！