
Hi Wolfgang, On Wed, Feb 19, 2003 at 08:59:24AM +0100, Wolfgang Rosenauer wrote:
But now I get many errors because many statements are doing things like this:
SELECT count(*) FROM ticket as st, queue as sq, personal_queues as suq, ticket_state tsd, ticket_lock_type slt ...
the keyword "as" is not accepted by SAPDB and its right. IMHO is this keyword not allowed here.
Is it working if you use the same statement without "as"?
it seems so. The modified statement doesn't throw an error any longer. But I was not able to log in as root yet, because I didn't have the time to modify all statements, which are performed while login. So I cannot really decide if the system works.
Hmm... Wolfgang, is it possible to get a shell account on a machine with SAPDB? So I could play a little bit!
CU, Wolfgang
Martin -- Martin Edenhofer - <martin at edenhofer.de> - http://martin.edenhofer.de/ -- "Security is a process, not a product." - Bruce Schneier