Liferay and Oracle DB

Question

I'm installing liferay community edition with an Oracle database, I managed to get it running with the user SYSTEM, but I don't like this... I want to create another user in another tablespace, the problem is that it seems that liferay needs to create tables and alter them according during its lifetime.

Do you know what permission and roles need to be assigned to the user?

Thanks a lot in advance.

score 1 · Answer 1 · answered Mar 15 '11 at 01:06

1

The default Oracle install normally has a USERS tablespace. If you are happy with that, try

CREATE USER liferay IDENTIFIED BY password DEFAULT TABLESPACE users QUOTA UNLIMITED ON users; GRANT CREATE SESSION, CREATE TABLE, CREATE TRIGGER, CREATE SEQUENCE, CREATE VIEW TO liferay;

That might be sufficient. If the setup script errors, then other permissions may be required.

answered Mar 15 '11 at 01:06

Gary

1,839
10
14

Ok, that seems to be working, thanks a lot for your help! – iamedu Mar 15 '11 at 16:20
FYI: The extra permissions are only required during installation or update (or deployment of new plugins) - during the "normal" runtime, only the standard operations SELECT, INSERT, UPDATE and DELETE are required. – Olaf Jun 19 '11 at 09:17

score 1 · Accepted Answer · edited Dec 14 '19 at 19:17

Be careful using the USERS tablespace. It's not technically good practice, but it will work fine.

Here's what I use and it works pretty well.

CREATE TABLESPACE LPORTAL7 DATAFILE '/opt/oracle/data/liferay_01.dbf' SIZE 2G AUTOEXTEND ON MAXSIZE UNLIMITED;
CREATE USER LPORTAL7 IDENTIFIED BY <password> DEFAULT TABLESPACE LPORTAL7;
GRANT CONNECT, RESOURCE, CREATE VIEW TO LPORTAL7;
ALTER USER LPORTAL7 QUOTA UNLIMITED ON LPORTAL7;

Liferay and Oracle DB

2 Answers2