|
-
Hi,
We have implemented fgac in a different way bcos of our requirements.
If I have understood your requirements properly:
but as u say that the levels are hierarchical why dont you have a table that has the parent_level and use a hierarchical query and include the list in the dynamic where clause. say if a user has level 3 which is admin and its child_levels are 2,1 the where clause will be level in (3,2,1).
If you have 9i, all these are provided by oracle's OLS and you dont have to worry abt anything.
HTH,
-dharma
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|