This is correct. There is no "you get access to everything" kind of clearance. That includes the President. Congress has the power to get access to anything, but even then there is a tight process limited to a handful of congresspeople.

A core part of this sort of security is compartmentalization. A person who has "top secret" level clearance has it for specific subject matter. Their clearance is worthless if they're outside those boundaries.