[CWB] Problems with CQPweb frequency list permissions

[Hardie, Andrew]

The reason for the clunky system whereby freq lists are controlled by privileges, whereas the sort/collocation/distribution databases are controlled by a separate setting applied to each user, is boring and historical: the latter system was a feature duplicated from BNCweb long ago, the former system added later with the intent to design a more flexible system for permissions not just for frequency lists but also corpus access and, potentially, everything else too. 

**At some point** the user database limit will be removed, to be replaced by a new type of privilege. But I can't prioritise this because the system as it is does _work_ after all.

Sorry!

Andrew.


-----Original Message-----
From: cwb-bounces at sslmit.unibo.it <cwb-bounces at sslmit.unibo.it> On Behalf Of Stephanie Evert
Sent: 06 April 2022 20:55
To: CWBdev Mailing List <cwb at sslmit.unibo.it>; Philipp Heinrich <philipp.heinrich at fau.de>
Cc: Fabian Schäfer <fabian.schaefer at fau.de>
Subject: Re: [CWB] Problems with CQPweb frequency list permissions


> What am I missing?

Frequency list privileges are used for compiling frequency lists for subcorpora of the specified size.  They don't apply to other cached databases, such as collocation tables, frequency breakdown, etc.

Apparently the latter limit can only be changed for each individual user via the user admin page. The setting is at the very bottom of the page, just a little below the point where a sane person has given up on scrolling down.

It is set to 1,000,000 rows for the users in question, and 10,000,000 rows for cqpwebadmin, which seems to explain the behaviour you're seeing.

> This is bizarre because (a) a breakdown of 300,000 matches should have less than 1 mio. instances and (b) the user has been explicitly granted the right to build frequency lists of up to 1 billion tokens.

The 1,000,000 limit should allow you to do a frequency breakdown of 300,000 matches, but for a collocation database the # of matches is multiplied by a (default) cost factor of 4, giving an effective table size of 1,200,000 > 1,000,000 rows.

Best,
Stephanie
_______________________________________________
CWB mailing list
CWB at sslmit.unibo.it
https://eur02.safelinks.protection.outlook.com/?url=http%3A%2F%2Fliste.sslmit.unibo.it%2Fmailman%2Flistinfo%2Fcwb&amp;data=04%7C01%7Chardiea%40live.lancs.ac.uk%7C82fa43bf3912413a0cdc08da18077c0b%7C9c9bcd11977a4e9ca9a0bc734090164a%7C0%7C0%7C637848717951203664%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&amp;sdata=a5FoFwbiizpJ2i2Cje9wEVMCPTaIGGMphMQRoaqdS0s%3D&amp;reserved=0