Hi Elke Thanks for the answer, but dont work.
>> >> 1)===== >> Connected on the server through telnet or ssh, with dbmcli : >> >> = Create user ABC (with many rights, near dbm, and of course >> SQL rights) >> >> = User ABC create and feed a little CLIENT table. >> >> All seem to be nice with dbmcli; DBA, DBM and ABC have access >> to the CLIENT >> table. >> >> 2)===== >> Now connected on the server with Mozilla and websql : >> >> Under DBA the basic SQL: "select * from tables" work. >> But "select * from CLIENT give an error: table dont exist ?!?!?! >> So user ABC get same error.>> >database users, not being the owner of an object (a table, sequence,...) >have to specify the owner in front of the objects name >--> select * from ABC.CLIENT >This is the common SQL-behaviour.> ??? I have try users DBA and ABC through websql "select * from ABC.CLIENT" (or DBA.CLIENT and DBM.CLIENT) no more success ? Jean Louis >Only special (predefined) views like TABLES differ >from that. Their owner will be appended implicitly. >We will NOT append other owners implicitly, otherwise >people having privileges for ABC.tab1 and DEF.tab1 >would never know which own was used when only tab1 >was specified. >Elke >SAP Labs Berlin >> I have try to find explanation in documentation (its clumsy, >> very difficult to >> use) and so in this mailing list archive. >> >> I have found that perhaps "GUIRIGHTS" user parameters can >> help me, but... it >> seem to not be used to day. >... _____________________________________________________________________ GRAND JEU SMS : Pour gagner un NOKIA 7650, envoyez le mot IF au 61321 (prix d'un SMS + 0.35 euro). Un SMS vous dira si vous avez gagn�. R�glement : http://www.ifrance.com/_reloc/sign.sms _____________________________________________________________________ Envie de discuter en "live" avec vos amis ? T�l�charger MSN Messenger http://www.ifrance.com/_reloc/m la 1�re messagerie instantan�e de France _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
