Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Catalog navigation via views on SYSIBM.SYS* tables #174

Open
ClaudeBirtz opened this issue Oct 30, 2024 · 0 comments
Open

Catalog navigation via views on SYSIBM.SYS* tables #174

ClaudeBirtz opened this issue Oct 30, 2024 · 0 comments
Labels
enhancement New feature or request

Comments

@ClaudeBirtz
Copy link

Hello,

our developers access the catalog vie views that return only the information about the objects they are entitled to see.

For example

CREATE VIEW CIDB2.SYSTABLES AS
SELECT *
FROM "SYSIBM".SYSTABLES T
WHERE <predicates comparing CREATOR or OWNER to the value of CURRENT SQLID, limiting output to objects the user has the right to use>

I couldn't find a setting allowing us to use another creator than SYSIBM for queries on the catalog tables so I always end up with -551 when I use the extension catalog navigation.

Best regards,
Claude

@ClaudeBirtz ClaudeBirtz added the enhancement New feature or request label Oct 30, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
enhancement New feature or request
Projects
None yet
Development

No branches or pull requests

1 participant