Little has changed from Discoverer Admin/Disktop in 11g so I would start following the document "Using Discoverer 10.1.2 with Oracle E-Business Suite 11i" [ID 313418.1]. You will need to use add the correct version into the ICX profiles.
I create workbook through Discoverer desktop and save in database, Now I like to give assign these workbooks
to the user through Discoverer view , so that they can view these worksheets, How can I view these workbooks
through Discoverer view in oracle ebs 11i.
You should always logon to Discoverer Admin and Desktop using an EBS username and password. Once you have saved the workbook into the database you can share the workbook with other EBS users and responsibilities so that other users can run the workbook.