on 01-11-2017 10:39 AM
ST05 should tell the truth. If there is a restriction for the user, it must be expressed in SQL there.Now you must check, if the restriction that you intend is really expressed in the conditions of the generated SQL.
In order to isolate the problem, maybe its a good idea to use Open SQL SELECT on the view in a little report to check its functionality and ST05.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
How do you check that the user is able to fetch all data?
Is s/he accessing the view with Open SQL (or SADL)? Only then, the implicit WHERE conditions are taken into account.
Did you use ST05 to check the SQL statement that is sent to the DBI from Open SQL when accesing your view? You should see the implicit WHERE conditions there.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
7 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.