Looking for some advice and some documentation on approaching the business to define security.
Current situation, we have a DW, healthy amount of stars, lots of data, and a fair amount of reports/dashboards. What we don't have are any security requirements.
My question is, in your past experiences, what are some of the best strategies to kick-off this process? Do you approach the execs, here are a list of Dashboards/KPis and reports, here are all the tables, columns and rows and you tell us which Role, group or user can see what?
Do you have some good templates that worked well in defining this process? and some good templates used for editing the security in the RPD?
Any feedback would be greatly appreciated,
Why cant you create some dummy roles and users 'Admin' / 'Super User' / 'User' using default LDAP authenticator in 11g on sandbox/dev environment (hope you on 11g ) ?
Admin --> All SA access
Super User -->kind of Author for specific /multiple SA
User --> Some specific reports/dashboards for single SA (with Row-level security&Object Level security)
Give Read/Full Control/No Access on catalog items.Prepare a document with your existing setup (no security) and compare with Role based security & data security
some good templates used for editing the security in the RPD
Is it Something related to SubjectArea and Column level acesss in RPD?