We usually take a cooler onboard with us that has soda/wine.
So far we are about 9 out of 10 on it just going through the xray machine with nothing further being said or done.
The most recent trip the security guy asked to open it and rummaged through to check that the cans were in fact soda/bubbly water and not beer ... nothing was said about the fact that there were about 24 of them.
As in all things Royal Caribbean there is no consistency but I would say unless you are trying to take hundreds of sodas on with you, you should be fine.
