Re: Minimum permissions for Log and DB

On 3/16/06, Bruno Barberi Gnecco <brunobg@gmail.com> wrote: > Hi, > > What is the minimum set of permissions that the database user needs > for Pear::Log? It seems that just giving permission for insert/update/ > select on the log table is not enough, since Pear::DB uses some mechanism > to increment the sequence counter that requires more than that... > If you're using PEAR::DB's sequence emulation it's going to try to create a table named "tablename"_seq where "tablename" is the name of the table. Give that user permission to create tables for the first run and look at what it created. For any further tables you may need just create a similar sequence table in advance. -- Justin Patrin