Jira 7.2.2 eliminated the functionality of shares (dashboards, filters) to be accessed by public/anonymous users if your instance is not public. I have numerous filters that have the "Shared with" field populated with "Shared with public" that I would like to change to "Shared with logged-in users" as a bulk. Anything "Shared with public" is moved to "Shared with logged-in users". Is this possible?
Pretty sure this is the solution:
1. Run the following query:
update SHAREPERMISSIONS
SET SHARETYPE = 'loggedin'
WHERE SHARETYPE = 'global' AND entitytype = 'SearchRequest'
2. Run the following query:
update SHAREPERMISSIONS
SET SHARETYPE = 'loggedin'
WHERE SHARETYPE = 'global' AND entitytype = 'PortalPage'
3.Restart JIRA
4. Perform indexing
Hi Rich,
Thank you for posting that solution here.
Cheers,
Branden
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
As in run that query against the database?
May I ask which database you are using? and if this worked successfully?
I'm a little hesitant to run a query against a database without knowing the impacts.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi John,
Yes. Run it against your database using a tool like SQL Developer. I used that tool to run the SQL statements against our Oracle DB and it worked perfectly.
If you are uncomfortable running these, please seek a DB Admin in your organization to review them. Also, check out the ref link where I identified the solution.
Hesitation to run a SQL statement against your DB without understanding what its doing is a good thing. :)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.