Hi I'm a new User from Germany an I use PHPRunner 4.2 (379) (trial) with ORACLE 11g
First of all: Its a nice great Tool. I make a WEB based database in 2 days.
But I have a problem with the dynamic permission.
When I will switch to dynamic permission I recived a message from ORACLE:
ORA-00903:invalid table name ...
To find the problem I make a PHPRunner project with a ACCESS database. There is the function OK.
Now I create the table manually in oracle. (CREATE TABLE "<schema>"."tablename" ...) an editing the .phpr file to use the dynamic permision feature.
The tables now in use! But the _ugrights table was no filling with the in PHPRunner used tables.
Inserting an new ADMIN user in PHP Runner is OK.
But when I start the WEB application an logging in with the adminuser i have no items in then menu page.
OK I think the Problem ist that the SQL Statement use the " character to quote the table name
(SELECT FROM "<schema>"."<tablename"<img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=8974&image=1&table=forumtopics' class='bbc_emoticon' alt=';)' /> now the tablenames are case senstiv
I Use now the the UPPER versions of tablenames but in the SELECT Statemens in commonfunctions.php use the lowerstringversion of the tablenames.
What can I do
Now the Dynamic
