Add private secret manager example and test

[kierramarie]

Description

A private only secrets manager example needs to be created and used in a test in the pr_test.go.

New or affected modules

---

By submitting this issue, you agree to follow our Code of Conduct

[ocofaigh]

@kierramarie I suggest you update the complete example to deploy private instance, and then also add a "basic" example which just creates a basic secret over pubic endpoint