Problems with "GRANT"

Hermann Himmelbauer <[email protected]> Tue, 16 Sep 2003 15:16:50 +0200
Newsgroups gmane.comp.db.sapdb.general
Message-ID <[email protected]>
Hi,
I use SAPDB 7.4/Linux and cannot pass rights to other users via the "grant" 
sql command.

I created a table "movie" as user "dusty", inserted some data and now want to 
pass rights on this table to a user "www".

I did the following:

1) as DBA:
create user www password *** STANDARD not exclusive

2) as "dusty":
grant ALL on movie to www

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?

		Best Regards,
		Hermann

-- 
[email protected]
GPG key ID: 299893C7 (on keyservers)
FP: 0124 2584 8809 EF2A DBF9  4902 64B4 D16B 2998 93C7