Yes. As long as you've "activated" your console with the secondary account, you may use the games and DLC bought in it by different users on the same console.
There may be some exceptions to this (I know of a single game and a couple of DLC), but to be on the safe side, on the store's product page, look for the disclaimer
One time fee for use of downloads on up to 2 activated compatible Home Console systems.
For comparison, here's what the disclaimer on a "single user" game looks like:
One time fee for use of downloads solely by the purchasing Sony Entertainment Network account on up to 2 activated compatible Home Console systems. No more than 1 activated compatible Home Console system within a 24 hour period. Content may not be used by any other account. You must sign in to PSN each time you start the game.