In Fable 3 for the Xbox 360, you can open the the Aurora Demon Door by being extremely good or extremely evil. It can’t be accessed until after the revolution since it has rubble blocking it until then.
This demon door simply wants you to be 100% good or evil. Once you are 100% in either of these, the door will open for you and you’ll find a legendary weapon inside.