On Wednesday 17 September 2003 07:26, Anhaus, Thomas wrote:
> Herrmann Himmelbauer wrote :
> >3) as "www":
> >select * from movie
> >-> [SAP AG][LIBSQLOD SO][SAP DB]Base table not found;-4004 POS(15) Unknown
> >table name:MOVIE.
> >
> >Why can user "www" not see table "movie" although I granted all rights to
> > him?
>
> You have to tell the database the schema containing your table. Without
> this information the table is expected in your own schema or in the schema
> of your dba.
>
> select * from dusty.movie
Thank you for the quick answer.
This was different in ADABAS 10.0.
I would like to know if one can set something like "default schemes" so that
you can write "select * from movie" instead "select * from dusty.movie".
Best Regards,
Hermann
--
[EMAIL PROTECTED]
GPG key ID: 299893C7 (on keyservers)
FP: 0124 2584 8809 EF2A DBF9 4902 64B4 D16B 2998 93C7
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
