Page 1 of 1

New Folder access tocertain Users not all

PostPosted: Sat Sep 09, 2017 5:05 pm
by jgraythe4th
Is there a way to add a folder, under the Media Folder tab in settings, where that it does NOT give all my users access to it. I want to be able to add a folder and add Users to the folder individually.

Re: New Folder access tocertain Users not all

PostPosted: Sat Sep 09, 2017 8:43 pm
by Michael Bech Hansen
It seems that new media folders by default are available to all existing users...

So you will have to disallow access to the new media folder for each user that should not have access:
- Login to server web interface as admin
- Goto Subsonic settings -> Users
- For each user uncheck the appropriate media folder(s)

Re: New Folder access tocertain Users not all

PostPosted: Mon Oct 22, 2018 11:30 pm
by audiosteve
Can anyone answer this? It is my largest management headache. Id I add a folder how do I set things up so everyone doesn't auctoamitcally have access to it (and all others as well when adding a person)

Re: New Folder access tocertain Users not all

PostPosted: Tue Oct 23, 2018 7:32 pm
by J_T_W
I don't believe you can do this at a sub-folder level, only at a root media folder level, then per-user.

Re: New Folder access tocertain Users not all

PostPosted: Tue Oct 23, 2018 8:09 pm
by audiosteve
Thanks for your reply, but... do you believe this can't be done or do you know it can't be done?
There has to be script change that can un check all the boxes, instead of checking them, be default.

Unfortunately I don't know enough to know where the script is saved or what to change.
I'll poke around and see what I can find. But if anyone out there knows......
thanx

Re: New Folder access tocertain Users not all

PostPosted: Tue Oct 23, 2018 9:48 pm
by J_T_W
I don't know about scripting, but you might be able to manage something via the <installdir>\data\db\subsonic.script (if you're on Windows), or if it isn't that frequent, perhaps manual manipulation via the http://<server:4040>/db.view SQL query window could be useful. A quick query to identify tables/fields is:

Code: Select all
SELECT TABLE_NAME, COLUMN_NAME, TYPE_NAME, IS_NULLABLE FROM INFORMATION_SCHEMA.SYSTEM_COLUMNS WHERE TABLE_NAME NOT LIKE 'SYSTEM_%'

Re: New Folder access tocertain Users not all

PostPosted: Tue Oct 23, 2018 11:42 pm
by audiosteve
Thanks for the tip. That all looks like database stuff, not presentation options. That would only be relevant if a new user had a default database entry with default values set. I'll look closer.
BTW, those files you referenced are in var/subsonic/db on the linux distro I am using.