SQL Injection (intro) 5: Data Control Language (DCL) the wiki's solution is not correct · Issue #1031 · WebGoat/WebGoat · GitHub
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.

Sign up for GitHub

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

Jump to bottom

SQL Injection (intro) 5: Data Control Language (DCL) the wiki's solution is not correct #1031

Closed
rikonaka opened this issue Aug 25, 2021 · 4 comments
Closed

SQL Injection (intro) 5: Data Control Language (DCL) the wiki's solution is not correct #1031

rikonaka opened this issue Aug 25, 2021 · 4 comments
Assignees
@nbaars
Labels
4 - Done waiting for release Issue is fix, waiting on new release
Milestone
8.2.2

Comments

@rikonaka
Copy link

rikonaka commented Aug 25, 2021 •
edited
Loading

图片
So, what's the correct solution for this lession 😂
And I have tried this but it's still not correct

GRANT ALTER TABLE ON grant_rights TO unauthorized_user
@github-actions
Copy link

Thanks for submitting your first issue, we will have a look as quickly as possible.

nbaars added a commit that referenced this issue Sep 5, 2021
@nbaars
#1031: Fix lesson
2212793 
- Hints not shown
- Add more hints
- Incorrect grant statement in lesson as example (removed it)
nbaars added a commit that referenced this issue Sep 5, 2021
@nbaars
#1031: Fix lesson
7ec6826 
- Hints not shown
- Add more hints
- Incorrect grant statement in lesson as example (removed it)
@nbaars
Copy link
Collaborator

nbaars commented Sep 5, 2021

@rikonaka fixed, updated the lesson and the hints etc. Thanks for reporting this issue.

@nbaars nbaars self-assigned this Sep 5, 2021
@nbaars nbaars added this to the 8.2.2 milestone Sep 5, 2021
@nbaars nbaars added waiting for release Issue is fix, waiting on new release 4 - Done labels Sep 5, 2021
@nbaars nbaars closed this as completed Sep 5, 2021
@purevoc
Copy link

purevoc commented Mar 31, 2022

@rikonaka A command that worked for me is:

GRANT all ON grant_rights TO unauthorized_user

I had trouble with this problem and used the exact same command you tried initially, this should work though and I hope it helps!

@ghost
Copy link

ghost commented Jun 19, 2024

grant all on grant_rights to unauthorized_user;
this query is working.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@nbaars nbaars

Labels
4 - Done waiting for release Issue is fix, waiting on new release
Projects
None yet
Milestone
8.2.2
Development

No branches or pull requests
3 participants
@nbaars @rikonaka @purevoc