Last modified: 2013-09-03 11:47:44 UTC

Wikimedia Bugzilla is closed!

Wikimedia migrated from Bugzilla to Phabricator. Bug reports are handled in Wikimedia Phabricator.
This static website is read-only and for historical purposes. It is not possible to log in and except for displaying bug reports and their history, links might be broken. See T47895, the corresponding Phabricator task for complete and up-to-date bug report information.
Bug 45895 - Use "_p" suffix on databases to make them readable by all users
Use "_p" suffix on databases to make them readable by all users
Status: RESOLVED WONTFIX
Product: Wikimedia Labs
Classification: Unclassified
bots (Other open bugs)
unspecified
All All
: Normal normal
: ---
Assigned To: Peter Bena
:
Depends on:
Blocks:
  Show dependency treegraph
 
Reported: 2013-03-08 11:13 UTC by Kunal Mehta (Legoktm)
Modified: 2013-09-03 11:47 UTC (History)
1 user (show)

See Also:
Web browser: ---
Mobile Platform: ---
Assignee Huggle Beta Tester: ---


Attachments

Description Kunal Mehta (Legoktm) 2013-03-08 11:13:44 UTC
On the Toolserver, if you name a database and it has the suffix "_p", any toolserver user can read it and query it.

From an end user perspective, this is much easier than trying to figure out how mysql permission settings work.
Comment 1 Peter Bena 2013-03-08 11:19:18 UTC
MariaDB [(none)]> grant select, usage on `\_p%` . * to '%'@'%';
Query OK, 0 rows affected (0.00 sec)
Comment 2 Peter Bena 2013-03-08 11:22:37 UTC
need to be consulted with someone who understand mysql better :/
Comment 3 Peter Bena 2013-09-03 11:47:44 UTC
bots project is getting closed

Note You need to log in before you can comment on or make changes to this bug.


Navigation
Links