i am using Oracle and would like to restrict end user to certain number
of rows.
Can we use a stored function in the where clause of rows restriction tab
of supervisor module.
I’m not sure I understand what you’re asking, but you can set a different
row limit for every user for every universe in your repository if you so
choose.
In supervisor, select the user you want to restrict on the left. Click the
Universe tab on the right and double-click the universe you want to apply
this row limit to. This will bring up the Universe Properties dialog. The
title of this dialog box will indicate the name of the universe and the name
of the user affected.
Click on the Controls tab in the Properties dialog. Change the “Limit size
of result set” option as desired. As mentioned above, this only affects the
one user and universe selected.
In a message dated 99-02-25 11:41:11 EST, you write:
Can we use a stored function in the where clause of rows restriction tab
of supervisor module.
You can use a stored database function anywhere you can use normal SQL, so I
believe this answer would be yes. By creating a “where” clause in Supervisor,
you can restrict the rows for a particular table. If you need to use a stored
function, something like:
table.column = my_function(table.column)
then you are okay. Note that you cannot use stored procedures here; they are
not valid in an actual SQL statement.
If u want to restrict the users in seeing certain rows depending upon the
value of fields then u use the where clause of the row restrictions tab in
the supervisor module…
If u want to restrict the number of rows in the result i.e. the report then
use the controls tab in the supervisor module and check the limit the number
of result rows and enter the maximum number of rows u want to allow the
users to see in their reports