Re: how to create an admin user for restore database.

Le 23/06/2010 05:17, Sam Wun a écrit :
> With user liferayadmin on db liferay, I got the following errors:
>
> 03:14:50,558 WARN [DBUtil:474] ERROR: permission denied for relation
> quartz_locks: insert into QUARTZ_LOCKS values('TRIGGER_ACCESS');
> 03:14:50,567 WARN [DBUtil:474] ERROR: permission denied for relation
> quartz_locks: insert into QUARTZ_LOCKS values('JOB_ACCESS');
> 03:14:50,582 WARN [DBUtil:474] ERROR: permission denied for relation
> quartz_locks: insert into QUARTZ_LOCKS values('CALENDAR_ACCESS');
> 03:14:50,593 WARN [DBUtil:474] ERROR: permission denied for relation
> quartz_locks: insert into QUARTZ_LOCKS values('STATE_ACCESS');
> 03:14:50,608 WARN [DBUtil:474] ERROR: permission denied for relation
> quartz_locks: insert into QUARTZ_LOCKS values('MISFIRE_ACCESS');
>
> ...
>
> How can I assigne admin permission to liferayadmin user?
>

ALTER ROLE liferayadmin SUPERUSER;

as the fine manual says (see
http://www.postgresql.org/docs/8.4/interactive/sql-alterrole.html)

--
Guillaume
http://www.postgresql.fr
http://dalibo.com