Skip to content

Reduce output of the SHOW GRANTS command#7506

Merged
dyemanov merged 5 commits intoFirebirdSQL:masterfrom
TreeHunter9:master_show_grants_change_output
Apr 22, 2023
Merged

Reduce output of the SHOW GRANTS command#7506
dyemanov merged 5 commits intoFirebirdSQL:masterfrom
TreeHunter9:master_show_grants_change_output

Conversation

@TreeHunter9
Copy link
Copy Markdown
Contributor

From:

GRANT SELECT, UPDATE (PLG$ACTIVE) ON PLG$VIEW_USERS TO PUBLIC
GRANT UPDATE (PLG$FIRST_NAME) ON PLG$VIEW_USERS TO PUBLIC
GRANT UPDATE (PLG$GID) ON PLG$VIEW_USERS TO PUBLIC
GRANT UPDATE (PLG$GROUP_NAME) ON PLG$VIEW_USERS TO PUBLIC
GRANT UPDATE (PLG$LAST_NAME) ON PLG$VIEW_USERS TO PUBLIC
GRANT UPDATE (PLG$MIDDLE_NAME) ON PLG$VIEW_USERS TO PUBLIC
GRANT UPDATE (PLG$PASSWD) ON PLG$VIEW_USERS TO PUBLIC
GRANT UPDATE (PLG$UID) ON PLG$VIEW_USERS TO PUBLIC
GRANT DELETE, INSERT, SELECT, UPDATE, REFERENCES ON PLG$USERS TO VIEW PLG$VIEW_USERS

To:

GRANT SELECT, UPDATE (PLG$FIRST_NAME, PLG$GID, PLG$GROUP_NAME, PLG$LAST_NAME, PLG$MIDDLE_NAME, PLG$PASSWD, PLG$UID) ON PLG$VIEW_USERS TO PUBLIC
GRANT ALL ON PLG$USERS TO VIEW PLG$VIEW_USERS

Comment thread src/isql/show.epp Outdated
@dyemanov dyemanov self-assigned this Apr 21, 2023
Comment thread src/isql/show.epp Outdated
Copy link
Copy Markdown
Member

@dyemanov dyemanov left a comment

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

I see no problems with this PR. Unless anyone else objects, I will merge it over the weekend.

@dyemanov dyemanov merged commit 043392e into FirebirdSQL:master Apr 22, 2023
@TreeHunter9 TreeHunter9 deleted the master_show_grants_change_output branch May 17, 2024 14:26
@TreeHunter9 TreeHunter9 restored the master_show_grants_change_output branch May 17, 2024 14:26
@TreeHunter9 TreeHunter9 deleted the master_show_grants_change_output branch May 17, 2024 14:26
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Projects

None yet

Development

Successfully merging this pull request may close these issues.

3 participants