Search results for query: *

Mufasa, Tracking WHEN the grant occurred is the main objective, in addition to WHO, WHOM, WHAT & WHICH. What are the main concerns with turning on the auditing for grants? I already have it on for DDL statements. Also, I don't see any rows in user_tab_privs nor user_col_privs. I have rows in...

Objective ========= I want to audit any grants made on my database objects. In addition to the basic information(timestamp, grantor, DB object, machine name, IP address etc.), I want to track the level of access granted (insert, delete, update, select) and the grantee. Current Solution...

Actually, the sub-report loads a couple of arrays with currency conversion rates and effective dates. Since the transactions can be in different currencies and have different dates, I need to compute the converted amount in the report for efficiency purposes. I could potentially create a stored...

Ido, thanks for the reply. The Order amount field is computed off of complex logic in a sub-report embedded in the main report header. I cannot move this piece of logic to the database end as it would mean hitting the database for every single Order transaction and thereby resulting in poor...

Ido, thanks for the reply. The Order amount field is computed off of complex logic in a sub-report embedded in the main report header. I cannot move this piece of logic to the database end as it would mean hitting the database for every single Order transaction and thereby resulting in poor...

Jim, Thanks for your reply. TopN sort is not available as the amt field is a manual value(computed off of complex logic in a sub-report embedded in the main report header). Arrays have a limitation of 1000 elements. Hence I can't use those either. Sincerely, jigitty.

Hi, I am using CR 9.0. In report of Vendors and their Orders I have grouping on Vendor Name: Details section : Order ID and order amount(using complex formula). Group 1 footer : Vendor Name and total order amount for that Vendor Now I want to generate a report which contains only Vendor Name...

Hi, I am using CR 9.0. In report of Vendors and their Orders I have grouping on Vendor Name: Details section : Order ID and order amount(using complex formula). Group 1 footer : Vendor Name and total order amount for that Vendor Now I want to generate a report which contains only Vendor Name...