Liferay 6 - Reset guest permissions

[13年前 に Bruno Antunes によって更新されました。]

We have removed guest permissions from the guest page, and now we can´t login; no matter what page you access. We get the error with "You do not have permission to view this page".

Anyone knows how to fix this?

I know how to get id for the guest user role with

SQL> select companyid,roleid from role_ where name = 'Guest';

Permissions seems to be set under RESOURCEPERMISSION TABLE, in actions columns

We can get current RESOURCEPERMISSION's with

SQL> select * from RESOURCEPERMISSION where roleid=<GUEST ROLE ID>

What values do we need to put in RESOURCEPERMISSION.ACTIONIDS ?

regards,
--
Bruno Antunes

[13年前 に Hitoshi Ozawa によって更新されました。]

I haven't and don't want to try this on my system, but you can't even login with your admin user/password?

[13年前 に Bruno Antunes によって更新されました。]

In order to workaround this i have copied RESOURCEPERMISSION that existed for Admin (but not in Guest) to Guest

After this I am able to login. Then we can fix permissions for guest in portal.

I guess that we should only need to now the correct entry entry in LAYOUT, get is PID and add a new entry in RESOURCEPERMISSION with ActionsId to 2 (not tested)

regards
--
Bruno Antunes

[13年前 に Hitoshi Ozawa によって更新されました。]

Values of ACTIONIDS differ for resources.

1. Why don't you comment out database settings in portal-ext.properties so Liferay will create
a HSQL database \data\hsql\lportal.script

2. Copy both lportal.script and lportal.properties

3. Start up Liferay and delete guest permission on the guest page

4. Shutdown Liferay

5. Compare backup copy or lportal.script with the current lportal.script and find which value were changed in the RESOURCEPERMISSION

I have to say that you're threading on thin ice here.

[8年前 に Suyash Bhalekar によって更新されました。]

Kindly refer below link, this will help your cause.
http://stackoverflow.com/questions/17338193/unable-to-login-after-removing-guest-role-view-permission-on-landing-home-page/17338418#17338418