I have 20,000 users, we have to generate reports.

[system]

@johnedward

If i want to keep row level security for 20,000 users it is difficult for me to keep row level security for each and every user

You don’t need to apply the security for each and every user. Instead, create Groups of users and apply security as per your requirement.
Please have a look at this post for basics.

120×120 10.4 KB

How can I use the current system date in an object? You use a different function for each database. For example, Oracle users would typically use sysdate while Sybase or SQL Server users would use getdate(). Teradata uses DATE, and DB2 uses CURRENT_DATE. Ask your DBA if you are unsure which method is appropriate for you. Ok, so I have done that, but my object does not parse. How can I fix it? These functions or pseudo-columns do not need to reference a table. Yet when De…

---

zack (BOB member since 2007-08-02)