Herrmann Himmelbauer wrote : >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? 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 will work. Best Regards, Thomas -- Thomas Anhaus SAP DB, SAP Labs Berlin [EMAIL PROTECTED] http://www.sapdb.org/ _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
