Am I correct in that I need
- USAGE and CONNECT on the Database
- USAGE on the Schema (Given implicitly to schema owner)
- SELECT on the Table (Given implicitly to table owner)
To see these privileges we need to understand acl entries:
- Use
l+to see privileges of Database - Use
dn+to see privileges of Schemas - Use
dp+to see privileges of Tables
Privileges are seen here
That’s correct and complete; the only exception is that there is no USAGE privilege on databases, so you don’t need that.