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

lambda_function_restrict_public_access.sql query not evaluating correctly #421

Closed
rajlearner17 opened this issue Jun 23, 2022 · 0 comments · Fixed by #422
Closed

lambda_function_restrict_public_access.sql query not evaluating correctly #421

rajlearner17 opened this issue Jun 23, 2022 · 0 comments · Fixed by #422
Assignees
Labels
bug Something isn't working

Comments

@rajlearner17
Copy link
Contributor

Describe the bug
A clear and concise description of what the bug is.

policy_std column is jsonb, hence the below statement will generate null which will move the checks to OK

 when policy_std -> 'Statement' ->> 'Effect' = 'Allow'
    and (
      policy_std -> 'Statement' ->> 'Principal' = '*'
      or ( policy_std -> 'Principal' -> 'AWS' ) :: text = '*'
    ) then 'alarm'

Steampipe version (steampipe -v)
Example: v0.3.0

Plugin version (steampipe plugin list)
Example: v0.5.0

To reproduce
Steps to reproduce the behavior (please include relevant code and/or commands).

Expected behavior
A clear and concise description of what you expected to happen.

Additional context
Add any other context about the problem here.

@rajlearner17 rajlearner17 added the bug Something isn't working label Jun 23, 2022
@rajlearner17 rajlearner17 self-assigned this Jun 23, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working
Projects
None yet
1 participant