[SPT/CWIS] SPT--DBEntry.php shows a SQL error message; (solved?)

[Juan Zuluaga]

I granted a LOCK TABLES privilege to mysql user
sptcustom, and it seems to work. 

However, in general, does this list of grants sound
right to you? 
| GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP,
ALTER, LOCK TABLES ON `spt`.* TO
'sptcustom'@'localhost'   

--- Juan Zuluaga <jz31416 at yahoo.com> wrote:

> Dear SPT people, 
> 
> As an admin, when trying to add a resource, 
> either via clicking on the main page "add" little
> link,
> http://192.168.x.x/SPT/MetadataTool/SPT--DBEntry.php
> 
> or
> by going to the Metadata Tool green menu
>
http://192.168.x.x/SPT/MetadataTool/SPT--DBEntry.php?AddNewResource=1
> 
> the page complains saying
> 
> SQL Statement: LOCK TABLES Resources write, APUsers
> read, APSessions write, APSessionData write
> SQL Error: Access denied for user
> 'sptcustom'@'localhost' to database 'spt'
> 
> However, editing a record works OK
>
(http://192.168.x.x/SPT/MetadataTool/SPT--DBEntry.php?ResourceId=21)
> 
> The same error appears when trying to import data, 
>
http://192.168.x.x/SPT/MetadataTool/SPT--ImportDataExecute.php
> "SQL Statement: LOCK TABLES Resources write, APUsers
> read, APSessions write, APSessionData write
> SQL Error: Access denied for user
> 'sptcustom'@'localhost' to database 'spt' "
> 


http://socioenlinea.blog.lemonde.fr/socioenlinea/
Comentarios sobre politica, sociedad y ciencia social.

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com