Add E2E spec for access keyword

What does this MR do and why?

This MR adds an E2E spec for access keyword.

Details on access keyword - !145206 (merged)

Issue for E2E spec - #444769 (closed)

MR acceptance checklist

Please evaluate this MR against the MR acceptance checklist. It helps you analyze changes to reduce risks in quality, performance, reliability, security, and maintainability.

Screenshots or screen recordings

NA

How to set up and validate locally

1. The spec should run just fine locally.
2. Pipeline should be green. 💚

Related to #429522