Re: Minimum permissions for Log and DB

On 3/17/06, Bruno Barberi Gnecco <brunobg@gmail.com> wrote: > Justin Patrin wrote: > > 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. > > Okay, this seems to be the permissions required, for user 'logger', > database 'dbname' and table 'log_table': > > GRANT SELECT, INSERT, UPDATE ON > dbname.log_table TO > 'logger'@'localhost' > GRANT SELECT, UPDATE, CREATE ON > dbname.log_id_seq TO > 'logger'@'localhost' > > I hope this is it. Who would be responsible for the documentation > or the development of Log::DB? > Look at the package's page. The maintainers are listed. -- Justin Patrin