Not technically, I understand your need to create and destroy EC2 instances, whether it's done via automation or not. About having permissions at the security group level, this can often be limited to viewing only the resource, as it is a networking firewall resource, usually who manages these objects are SDN or NaaS
Restoring a snapshot simply creates a new RDS instance.
So if you restore the prod DB snapshot to staging then you will be creating a new RDS instance with the restored data in it.
If both of the RDS instances are in the same aws account then
You will either have to delete/rename the staging DB and then restore the prod DB
If both of the RDS instances are ...
Finally I found the solution. The port 8080 should have been added to firewall and I had to create a new target group for port 8080 which then I had to create a load balancer with port http:8080 and point to the target group.