Note 16 - Non-controlling Interests (Details Textual)	Aug. 31, 2023	Aug. 31, 2021
Superhero Acquisition LP [Member]
Noncontrolling Interest, Ownership Percentage by Parent	68.00%	68.00%
CC Pharma Nordic ApS [Member]
Noncontrolling Interest, Ownership Percentage by Parent	75.00%
Aphria Diamond [Member]
Noncontrolling Interest, Ownership Percentage by Parent	51.00%
ColCanna S.A.S. [Member]
Noncontrolling Interest, Ownership Percentage by Parent	90.00%