Re: Problems with "GRANT"

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