2. PHPRunner General questions
  3. Oracle Database Connecting Issue
This topic is locked

Oracle Database Connecting Issue

 		6/3/2021 3:31:53 AM
PHPRunner General questions
P
 Pawnesh Kumar author

Hi Support Team,
We are trying to Login PHPRunner 10.5 using Oracle database ,
The Issue is that It's taking a very long time to get into it. If we check we found that it accessed all the tables & objects of the database. However we want only that user objects need to be accessed as there is sensitive data in other schema objects & need not to be exposed to all the users.
Request your support for the same How to restrict all objects while login through some specific user schema.
( Only that schema objects to be accessed).
Please suggest.

admin 6/3/2021

Things like this are handled on the database side. You need to make sure this database user only has access to required schemas.

P
 		Pawnesh Kumar author 6/3/2021

Hi, I created new User with connect only & create table rights. tried login through that new user even though few other schemas & there objects are visible inside.
HJB 6/3/2021

Working with Oracle Databases

... for inspiration purposes only. Judging on ".. the very long time ..." to get into it, the first thing to be done
is to ensure a proper and fast connection. You use a 64-bit computer ? But you are using PHPRunner 32-bit
version ?, so you need to install the Oracle client 32-bit. Next to it, on "sensitive data" seen in other schema
is a clear indicator that PHPRunner has so far NO full control (assuming that user rights to see what tabled content
has been done correctly ...). Since Oracle is world market leader within the banking industry (last known annual
licence fees known to me dates back decades ago and was $440,000 a year for a Quad Core computer) it is only
little wonder that Oracle needs to see to it that the connection to Oracle databases is happening under more secure
terms than e.g. a connection to MySQL or else.