Oracle Analytics Publisher Idea Lab

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

PASSWORD PROTECTION FOR EXCEL (.XLS) OUTPUT SENT THROUGH ORACLE BI PUBLISHER

618
Views
8
Comments
Rank 1 - Community Starter

Organization Name

Hilton Resorts Corporation

Description

The customer needs this functionality to password protect the Excel (.XLS) output because when they schedule BI Publisher reports that have output in Excel (.XLS) format and send the reports to clients by
contain critical business data.

Use Case and Business Need

The customer needs this functionality to password protect the Excel (.XLS) output because when they schedule BI Publisher reports that have output in Excel (.XLS) format and send the reports to clients by
contain critical business data.

Original Idea Number: 5d863e2d1f

Tagged:
6
6 votes

Submitted · Last Updated

Welcome!

It looks like you're new here. Sign in or register to get started.

Comments

  • Rank 2 - Community Beginner

    Many customers would find this useful - added security features for their data!

  • Rank 1 - Community Starter

    Certain data contained in our instance of Oracle needs to be protected as part of the General Data Protection Regulation (GDPR). These reports should have password protection to ensure that this data is still protected once it is exported from Oracle. 

  • Rank 1 - Community Starter

    This features is implemented in 19.D. 

    ENH 26197461 - ER: PASSWORD PROTECTION FOR EXCEL FILES SENT THROUGH ORACLE BI PUBLISHER

  • Rank 5 - Community Champion

    Great to know that this functionality is available now.

  • Rank 2 - Community Beginner

    Yes - looks as if it is all possible within the Report Properties, see the following Oracle doc;
    https://support.oracle.com/epmos/faces/SearchDocDisplay?_adf.ctrl-state=11pv7i7sqn_4&_afrLoop=245136443132064#FIX

  • Rank 4 - Community Specialist

    You can use password protect as of Release 19C for PPTX, DOCX, XLSX, PDF (the password protection will apply to both online viewed reports and scheduled jobs):

    TO APPLY PASSWORD PROTECTION

    • To apply password protection at server level (i.e. for all reports that generates the output in PPTX, DOCX, XLSX, PDF)
    1. Navigate to Administration page
    2. Open Properties under Runtime Configuration section
    3. Enter a desired password for the file formats
    • To apply password protection at report level (i.e. for only specific report for PPTX, DOCX, XLSX, PDF outputs)
    1. Edit a report
    2. Navigate to Report Properties, Formatting tab
    3. Enter a desired password for the file formats

    https://www.oracle.com/webfolder/technetwork/tutorials/tutorial/cloud/r13/wn/common/releases/19C/19C-common-wn.htm#F9055

    NOTE: Excel output in .XLS format generated from Excel templates do not support password protection.

  • Rank 2 - Community Beginner

    Hi Robert,

    Do you have any suggestions to add extra security to an .xls template? Or do you know why we need to make te excel template as .xls?
    Will oracle except .xlsx templates in the near future?

    Kind regards,

    Tessy

  • Rank 2 - Community Beginner

    Hi,

     

    Can someone tell me if the security on .XLS will be enabled? 

    If it will be possible in the future to use .XLSX templates instead of .XLS templates in BI Publisher?

     

    Kind regards,

    Tessy

Welcome!

It looks like you're new here. Sign in or register to get started.