jean louis argente wrote: > > 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. 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. > > Some help ? > > Thanks in advance > > Jean Louis > > > > > > _____________________________________________________________________ > 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 > > _______________________________________________ > 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
