Yes for ‘Embedded password’ : Allow workbook ‘interactors’ to access the published data sources it connects to No for ‘Prompt user’ To simplify permission settings: When publish workbooks, select ‘Embedded password’ for published data sources it connects to
Recommended Data Source Permission Settings - Option A1. Only give publisher group ’Connect’ permission at data source level 2. Do nothing for end consumer (‘interactor’) group at data source level - unspecified 3. When publish workbook, select ‘Embedded password’ 4. Test out (inc. web edit)Recommended Permissions If you use do not use ‘Embedded password’ when publish workbook using published data sources, you have to set permission at workbook level AND published data source level!
What Data Source ‘Connect’ Permission Does?Data Source - Connect: Allowing accessing data source from Web (via workbook) and Desktop ‘Connect’ allows users to get your Published data source via Desktop : potential vulnerability for interactorsData Source - View: Not good enough to access published data via workbook. User can see data source name, owners only Permission option B: 1.Workbook ‘Prompt user’ 2.Publisher group ’Connect’ permission at data source level 3.Interactior group ’Connect’ permission at data source level (Data source View permission will not work)
Set Data Source Permission Settings ‘Prompt User’Is there a permission setting that allows all the followings: 1. Workbook ‘Prompt user’ 2. Interactors can ‘see’ the data via workbook only but can’t connect via Desktop or Web edit at all? 3. Only allow publisher group connect to the published data sources?
Set Data Source Permission Settings ‘Prompt User’ - Option CInteractor group setup:Connect permission at project level ‘unspecified’ at data source levelPublisher group setup: Connect permission at data source level‘Prompt user’
Re-cap : Data Source Permission OptionsOptionsProjectWorkbookData SourceNotesOption AN/AEmbedded password• Connect for publishers only