| Oracle Discoverer doubts [message #203925] |
Thu, 16 November 2006 23:52  |
rkesavan
Messages: 6
Registered: October 2006
|
Junior Member |
|
|
hai friends,
I am using oracle discoverer (9ids release 2). my question is, i have 6 reports and 3 users (like manager,officer,clerk).
The manager have the privilege for view all reports, but officer and cleark have the privilege to view only specified reports.
is it possible to set these kind of privilege for users in discovererAs. if yes, how to do it. if any document or related site reference is highly appericiated.
i am waiting for urs valuable suggestions.
Thanks in advance.
with regards
kesavan.r
|
|
|
|
|
|
| Re: Oracle Discoverer doubts [message #204889 is a reply to message #203925] |
Wed, 22 November 2006 09:11  |
DiscoUser
Messages: 9
Registered: November 2006
|
Junior Member |
|
|
I am using oracle discoverer (9ids release 2). my question is, i have 6 reports and 3 users (like manager,officer,clerk).
The manager have the privilege for view all reports, but officer and cleark have the privilege to view only specified reports.
You can do this in 2 ways, depending on the type of reports and data. I am assuming you are using discoverer with Oracle applications.
You can share all the 6 workbooks to the Manager, and Share specific workbooks to the Officer and Clerk.
If the manager has different security than others, like Manager has Super User responsibility and others have regular user responsibility, you can share the workbooks to the responsibilities instead of to the users.
Example, WB1 thru WB6 are shared to GL Superuser Responsibility, and W1, W2 are shared with GL User Responsibility, if you grant Manager the GL Superuser Responsibility he can see all 6 reports. If you grant other users GL User Responsibility, they can see only 2 reports.
Hope this helps.
DU.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
