Correct, you'll need to manage the permissions manually in HDFS. The authorization model in Hive is just to prevent accidents. Hopefully, we'll address this eventually, but in the mean time it is strongly encouraged to set the permissions of your databases and tables in hdfs to the desired permissions.
-- Owen
