Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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.

share|improve this question

1 Answer 1

up vote 1 down vote accepted

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.

share|improve this answer
    
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 9:17

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.