Best practice to security Universes

[former_member300320]

We have a lot of universes and all users can see and create reports and queries using these universes.

What is the best practice to avoid a user to create a query using an universe that he could not be able to see.

[amitrathi239]

I have fixed your tags. Please select more careful next time.

[amitrathi239]

Follow below steps to restrict users to create/edit webi queries on universe.

Goto CMC->Universes->Universe folder->user security->select user/user group/Assign security->Advance->Add/remove rights->under System->Universe-> deny "Create and Edit Queries Based on Universe" right and click ok.

If you have UNX universe then under system->Universe (information design tool) deny"Create and Edit Queries Based on Universe" right and click ok.

After that all universe in the particular universe folders will not be visible to users to create reports but they can refresh existing reports.