A Hive database corresponds to a directory in HDFS. Each Hive table created in the database corresponds to a subdirectory. You grant
Enterprise Data Preparation
user accounts permission on the appropriate directory, based on whether you want to provide permission on a Hive database or on a specific Hive table in the database.
As a best practice, you can set up private/shared/public databases (or schemas) in a single Hive resource and grant users appropriate permissions on those corresponding HDFS directories.