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.

Any Help???

Regards Jan Scheider



_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general

Reply via email to