Oracle Bi Solutions

  • Subscribe to our RSS feed.
  • Twitter
  • StumbleUpon
  • Reddit
  • Facebook
  • Digg

Wednesday, 27 February 2013

OBIEE 11g Security - Creating Application Policies

Posted on 09:39 by Unknown

You can create Application Roles based on existing Application Policies that are installed by default  for Application Roles

So you can create your own Application Policies/Application Roles.

In below post we can see how a custom Application Policy can be created using Web logic Enterprise manager

The Application Policy defines the permissions grants. Permission grants are controlled  using Web logic Enterprise manager  
 


Application Role,Group,User are mapped to Application Policy based on permissions granted the Business intelligence content is visible to users

There are two methods for creating a new Application Policy:
  • Create New - A new Application Policy is created and permissions are added to it.
  • Copy Existing - A new Application Policy is created by copying an existing Application Policy. The copy is named and existing permissions are removed or permissions are added.

    Creating a New Policy : 
    Login to EM and Weblogic Domain - bi foundation Domain --Security -- Application Policies

    Click on Create button for a new application security grant

I am going to assign custom Application Policies for my Application Role 'Power User' as shown below

In the Grantee Add your application role in Permissions section click on Add by default the permission class  'oracle.security.jps.ResourcePermission' which contains all the Resource Type


Select the Resource Name and click on Continue and Select the Resource Name which will add to your Permissions section




POWER USER Application Role is assigned to below policies : 



POWER USER application role is member of BI Admin/BI Author/BI Consumer/Saichand_policy(user)

If a Application Role is part of BI Administrator then the user Should able have privilege to create report/dashboard but the policy which added above will have privilege to manage catalog but not create Analysis/dashboards


create an Application Policy based on an existing one:
It is the same process but here you need to select the application Role and click on Create like button



So new application role Super User has been  created using policies of BI Administrator as shown below




Few Application polices with description


Permission Name
Description
oracle.bi.publisher.administerServer
Enables the Administration link to access the Administration page and grants permission to set any of the system settings.
oracle.bi.publisher.developDataModel
Grants permission to create or edit data models.
oracle.bi.publisher.developReport
Grants permission to create or edit reports, style templates, and sub templates. This permission also enables connection to the BI Publisher server from the Template Builder.
oracle.bi.publisher.runReportOnline
Grants permission to open (execute) reports and view the generated document in the report viewer.
oracle.bi.publisher.scheduleReport
Grants permission to create or edit jobs and also to manage and browse jobs.
oracle.bi.publisher.accessReportOutput
Grants permission to browse and manage job history and output.
oracle.bi.publisher.accessExcelReportAnalyzer
Grants permission to download the Analyzer for Excel and to download data from a report to Excel using the Analyzer for Excel. Note that to enable a user to upload an Analyzer for Excel template back to the report definition, the permission oracle.bi.publisher.developReport must also be granted.
oracle.bi.publisher.accessOnlineReportAnalyzer
Grants permission to launch the Analyzer and manipulate the data. Note that to save an Analyzer template to a report definition, the permission oracle.bi.publisher.developReport must also be granted.
oracle.bi.server.impersonateUsers
This description is not available.
oracle.bi.server.manageRepositories
Grants permission to open, view, and edit repository files using the Administration Tool or the Oracle BI Metadata Web Service.
oracle.bi.server.queryUserPopulation
Internal use only.
oracle.bi.scheduler.manageJobs
Grants permission to use Job Manager to manage scheduled Delivers jobs.

Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Posted in OBIEE | No comments
Newer Post Older Post Home

0 comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Popular Posts

  • Upper Function
    In Oracle/PLSQL, the  upper function  converts all letters in the specified string to uppercase. If there are characters in the string that ...
  • OBIEE 11g Hide/Show Sections based on Dashboard Prompt
    allow a user’s interaction to hide/show certain sections of a dashboard. In this particular case the user wanted to choose either ‘Quarterly...
  • [OBIEE11g] - OBIEE Dashboard for Informatica Metadata Reporting
    The metadata that Informatica Power Center 8 retains in its repository can be exposed via OBIEE reports and dashboards. This metadata includ...
  • [ODI] - Frequently Asked Questions (FAQ)
    Here is a list of FAQs about Oracle Data Integrator 1) What is Oracle Data Integrator (ODI)? 2) What is E-LT? 3) What components make up Ora...
  • OBIEE 11g not showing new dashboard in the drop down menu
    When creating New dashboard in  OBIEE 11g, I have faced with issue that dashboard name did not show up in drop down dashboard menu. 1. When ...
  • Data Modeling: Schema Generation Issue with ERwin Data Modeler 7.3
    We are using Computer Associate’s ERwin Data Modeler 7.3 for data modeling. In one of our engagements, we are pushing data model changes to ...
  • Installation Informatica Powercenter 9.1 on Oracle Enterprise Linux 5.6
    Ingredients: Program Version Filename Oracle Express 11G 11.2.0 oracle-xe-11.2.0-0.5.x86_64.rpm SQL Developer 3.0 sqldeveloper-3.0.04.34-1.n...
  • Informatica Powercenter Workflow Manager Repository Navigator docking float issue
    In case you’re also experiencing where your Repository Navigator is not dock or attached and it seems just floating within Workflow Manager ...
  • [OBIEE11g] - Creating Dashboard Traversing Through Graph
    The general requirement asked for by customers is that they want to Click on the Main Dashboard Page’s Graph and be transferred to the other...
  • OBIEE 11g - Query Limit
    Query limit and number of minutes a query can run per physical layer database connection, follow the below steps. > Login to Repository u...

Categories

  • BI Publisher
  • DAC
  • DataWarehouse
  • Hyperion
  • Informatica
  • OBIEE
  • ODI
  • Oracle Applications EBS 12.1.3
  • Oracle Database
  • PL/SQL
  • SQL
  • Unix/Linux

Blog Archive

  • ▼  2013 (500)
    • ►  November (8)
    • ►  October (1)
    • ►  July (4)
    • ►  June (9)
    • ►  May (15)
    • ►  April (24)
    • ►  March (43)
    • ▼  February (73)
      • Remember Username and Password in Obiee11g
      • Change Locale in OBIEE 11g
      • Change Password in BI Publisher 111.1.6.0
      • OBIEE 11g - Change the Date Format/ Evaluate Function
      • OBIEE 11g - Enabling Sorting order for more than 1...
      • OBIEE 11g - Changing the NodeManager and weblogic ...
      • OBIEE 11g - Description ID column
      • Fact and Dimension from single source Table
      • OBIEE 11g - Denormalizing physical tables in BMM l...
      • OBIEE 11g - ADF Integration
      • BUG:12930924 SAG: CANNOT DISPLAY MORE THAN 300 OBJ...
      • OBIEE 11g - Hide Apply and Reset button
      • OBIEE 11g Security - Creating Application Policies
      • OBIEE11g startup error - An instance of the interf...
      • OBIEE 11g - Partial Update using Condition in Answers
      • OBIEE 11g - custom Date format in Answers
      • The boot identity may have been changed since the ...
      • OBIEE 11g - weblogic admin account creation
      • Informatica PC Upgrade from 861 to 91 Installation...
      • Installation Informatica Powercenter 9.1 on Oracle...
      • How to Start oracel Database 11gR 2 manually on Linux
      • OBIEE 11g - Installation on OEL 5.8
      • OBIEE 11.1.1.6.5 and J Developer Integration on Li...
      • Oracle SQL Developer :Enter full path for java.exe
      • OBIEE 11g - Unable to get file lock , will retry i...
      • OBIEE 11g - Changing Presentation Services Port Nu...
      • OBIEE 11g - Changing the background color on hover...
      • OBIEE 11g - Date Format change based on Locale Set...
      • OBIEE 11g - Javascript and CSS locations
      • OBIEE 11g - Removing the Gray Header from Reports
      • OBIEE 11g - Refreshing a report Everytime
      • OBIEE 11g - Adding Bookmark Link in Dashboard
      • OBIEE 11g - Searching a Text in Page
      • OBIEE 11g - Remember Username and Password
      • OBIEE 11g - Removing/ Deleting Report Links in a Page
      • OBIEE11g - Export to Excel issue
      • OBIEE 11g - Right-click interactions in Dashboard ...
      • OBIEE11g - Right Function
      • OBIEE 11g - Set Default currency in Dashboard
      • OBIEE 11g - Hide BI Portal Name
      • OBIEE 11g - Export or Print Dashboard Page
      • OBIEE 11g - Ldap authentication is failing when us...
      • OBIEE 11g - Warning: "Upgrade is recommended to th...
      • OBIEE 11g - [OracleBIServerComponent] [ERROR:1] [...
      • OBIEE 11g - State: HY000. Code: 10058. [NQODBC] [S...
      • OBIEE 11g - List of System/Predefined Session Vari...
      • OBIEE 11g - Writeback Steps
      • [OBIPS] [ERROR:1] [] [saw.security.odbcuserpopulat...
      • [ERROR:1] [] [] [ecid: 18c5ef9f7c3aec02:-1a7b1b1:1...
      • OBIEE 11g - Important Path Directories
      • OBIEE 11g - OBI Server and Presentation Cache Mana...
      • How to login to OBIEE 11g - With User and Password...
      • OBIEE 11g - Direct Query from Database, bypassed C...
      • OBIEE 11g - Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P
      • OBIEE 11g - Deploying RPD without BI Presentation ...
      • OBIEE 11g - Dashboard Selective View from Report L...
      • OBIEE11g - RPD Deployment Considerations
      • OBIEE 11g - Starting / Stopping Domain Services in...
      • OBIEE 11g - SQL Conditional COUNT & SUM
      • OBIEE11g - Security Migration
      • OBIEE 11g - Performance Tuning
      • OBIEE 11g - User Guide for BI Mobile
      • OBIEE 11g - Active Directory Authenication
      • OBIEE 11g - Security Troubleshooting
      • DAC - Error "main" java.lang.NoClassDefFoundError...
      • DAC11g Starting issue (-server)
      • OBIEE 11.1.1.6.7 Opatch Apply from 11.1.1.6.0 to 1...
      • OBIEE 11.1.1.6.8 - bugs fixed
      • Informatica Powercenter Workflow Manager Repositor...
      • DAC - Restrict the number of years using Mcal Peri...
      • DAC - Global Currency Code Issue in dac
      • Hyperion Installation 11.1.2.1.0 on Linux 32 Bit
      • OBIEE 11g - Deploying RPD on Linux to Access the L...
    • ►  January (323)
Powered by Blogger.

About Me

Unknown
View my complete profile