User levels mAirlist database server

Archive mAirList 4.x (English)
1

Hi Torben,

We are using the mAirlist Database Server application. But i am wondering what the different user levels can do.
I understand that ‘read-only’ only can view the database, and that ‘Administrator’ has full rights, but how about ‘DJ’, ‘Folder Manager’, ‘Studio’ and ‘Manager’?

2

Roles are:

  1. read only = well, the name says it
  2. studio = read only + write access to the playlistlog table so that studio computers can write the playlist history, but studio operator cannot use the default connection to make any write operations in the database library or playlist
  3. dj = studio + playlist editiing
  4. folder manager = dj + can move items between folders in the library
  5. manager = folder manager + full write access to the library
  6. admin = manager + permission to adjust database configuration/basic scheduler settings
3

Is it possible to have custom versions of the above permissions i.e giving someone the ability to edit the content but not to edit the playlist.

4

Not when using the Database Server.

For direct PostgreSQL access, you could just create a new user/role and manually add the required table permissions using the GRANT command.

5

So it is possible to do this through PostgreSQL and would it then be possible to log in with Mairlistdb.