[EMAIL PROTECTED] wrote: > Hi, > > I'm a nebie with a question. > > I want to create a view only showing rows belonging to the > user owning the > current session. > I tried the following as some user: > select * from zadmin.t_arbeitszeiten > > where UPPER(az_ma_id) = (select username from sys.user_users) > > everthing is fine. > > Using this statement in an create view statement works, but > when executed by > a another user I always get "No Result". Users have select, > insert, update > on both the source table and the view.
Don't use the long way, use the register-name USER instead of the subselect. The other users are defined without " " around, so that the UPPER on the left side is correct for them, too? Elke SAP Labs Berlin _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
