SQL开发人员:为其他用户生成数据库文档 [英] SQL developer: generate DB doc for other user

问题描述

我的数据库中有一个Admin用户.管理员用户有权访问所有数据库对象.我没有管理员用户的凭据.

I have a Admin user in our database. Admin user has access to all database object. I do not have credentials of Admin user.

我的应用程序还具有普通用户，该用户具有对Admin用户的许多对象的访问权限(选择/删除授予等).因此，在SQL Developer中，当我使用普通用户创建连接时，可以转到其他用户->管理员用户"，然后会看到许多表/视图/触发器/过程.

My application also has Normal user which has access privileges (select/delete grants etc) on many objects of Admin user. So in SQL developer, when I create connection using Normal user, I can go to "Other Users -> Admin User" and I see many tables/views/triggers/procedures.

当我尝试使用SQL Developer生成数据库文档时(右键单击连接名称->生成数据库文档...)，生成的文档仅包含由我的普通用户创建的对象.报告不包含来自管理员用户的对象，我的普通用户对其具有SELECT授予.如何将来自Admin用户的对象包括到生成的数据库文档中?我只想包含我的普通用户对其具有SELECT授予权限的Admin用户中的那些对象.

When I try to generate DB doc using SQL developer (Right click on connection name -> Generate DB Doc...), generated documentation contains only objects that are created by my Normal user. Report does not contain objects from Admin user, for whom my Normal user has SELECT grants. How can I include objects from Admin user into my generated DB documentation? I only want to include those objects from Admin user for whom my Normal user has SELECT grant.

推荐答案

不幸的是，这仅适用于连接的用户.这意味着您必须连接到Admin才能为Admin运行dbdoc.

Unfortunately, This only works for the connected user. That means you'll have to connect to Admin to run the dbdoc for Admin.

这篇关于SQL开发人员:为其他用户生成数据库文档的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！