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