如何获取特定用户有权访问的所有表-DB2 [英] How to get all the tables on which a particular user has access-DB2

问题描述

我需要知道特定用户在其上具有访问权限的所有表。

I need to know all the tables on which particular user let's say 'Abc' has any(read, write) kind of access.

在db2中有可能吗？ ？

Is this possible in db2?

推荐答案

尝试使用 SYSIBMADM.PRIVILEGES 管理视图。您可以在 DB2知识中心：

从SYSIBMADM.PRIVILEGES WHERE OBJECTTYPE =中选择AUTHID，PRIVILEGE，OBJECTNAME，OBJECTSCHEMA
'TABLE'AND AUTHID ='userID'


Try the SYSIBMADM.PRIVILEGES administrative view. You can find more about it in the DB2 Knowledge Center: SELECT AUTHID, PRIVILEGE, OBJECTNAME, OBJECTSCHEMA FROM SYSIBMADM.PRIVILEGES WHERE OBJECTTYPE='TABLE' AND AUTHID='userID'

这篇关于如何获取特定用户有权访问的所有表-DB2的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！