Hi forum,

I try to draw just out of an Oracle German Railways a few data. The connection stands, but I receive no Rows...
$conn = oci_connect ('dbuser', 'pwd', '//x.x.x.of x/Servicename');
if (! $conn) {
$e = oci_error ();
print htmlentities ($e ['message']);
exit;
} else {
echo "connection stands!";
}


$query = 'select table_name from user_tables';

$stid = oci_parse ($conn, $query);
oci_execute ($stid, OCI_DEFAULT);
while ($row = oci_fetch_array ($stid, OCI_ASSOC)) {
foreach ($row as $item) {
echo $item." ";
}
echo "\n";
}
oci_free_statement ($stid);
oci_close ($conn);


"This example lists all tables owned by the user"
is called it in the How To!

unfortunately, I receive only one "connection stands!"...

being able to do it vl. be, the fact that the Admin has prevented it, the fact that dbuser all tables via select table_name from user_tables may list?

Somebody an idea?
to thanks!

If you are sure then, the fact that the user with you connectest generally own Tables has put in?
attempt, nevertheless, otherwise, sometimes nen:

select 1+1 ergebnis from binary

Then you get back guaranteed a line, if everything functions...

2 it is given

Confirming dbuser no Tables has put in?

Jap, then there functions your connection, but the user has no tables...

The Admin means:

hello, the user DBUSER_STATISTIK is no Schemaowner and has therefore no tables. He has reading authorisations on the Views known to them.
shows a Query which everybody "known to me" Views Giving?

You are able to come it sometimes try:
select * from table_privileges where grantee! = 'PUBLIC'

of case the Views, nevertheless, for everybody are released, if the following Query limits the list something:
select * from table_privileges where owner of like' %SYS' and owner in ('of XDB', 'SYSTEM', 'ORDPLUGINS')

LG Ben

This claps!
now I get all Views listed:... GRAIN TEA: DBUSER_STATISTIK
OWNER: DWH
TABLE_NAME: DIM_KUNDE
GRAIN GATE: DWH
SELECT_PRIV: Y
INSERT_PRIV: N
DELETE_PRIV: N
UPDATE_PRIV: N
REFERENCES_PRIV: N
ALTER_PRIV: N
INDEX_PRIV: N...
to the understanding:
What exactly I see here?
"SELECT * FROM DIM_KUNDE" delivers an "ORA 00942: Table or View not available".
How I access a View?

If the table does not belong to the announced user, if you always have to do "pattern"."Object names" brag. After your above example probably "DWH"."DIM_KUNDE". the announced user must have Of course in addition also the authorisation SELECT.