Allow other user to see just one directory in my user folder

Question

I want to store mysql and postgres database dirs under my user folder, so is it possible to allow other users (_mysql and postgres) to access just directories they need (like ~/var/mysql and ~/var/postgres) using ACL without allowing them to see contents of other directories/files. If I add postgres allow list,search to ~ then postgres can read everything inside my user folder with read permission set for others. Or is it generally a bad idea and I'd better use folder outside my home folder to store such things?

Answer 1

is it generally a bad idea and I'd better use folder outside my home folder to store such things
you said it...just switch is and it
that's a yes....generally a bad idea, although i see it crop up on boards ALL the time. how do i let service X operate in this single subdirectory of my home?

Answer 2

From your tags, you are using OS X? Go to the Sharing preference pane of System Preferences and enable File Sharing. You can add any folder to the list to be shared, and select which users and groups have which permissions on it.