How to set the permission for 'Database Views' to create data source and views?
Answered
Hi,
In our product, we created a role with the capability to create data source and views.
My question is: how to set the permission options for 'Database Views' to make this role be able to create reports using existing Data Source and Views ?
Only check 'R', or both 'R' & 'U'?
Please see the screenshot in attachment.
Thanks
Files:
DatabaseViews.png
Hi Jessica,
Thanks for posting your question.
For your reference:
C- Create, R- Run, U- Update, D-Delete
So if you want to permit the user to Update then you need to choose U, otherwise just tick R to Run.
See how you go with it.
Please let me know if you have any other question.
Regards,
Mahe
Hi Jessica,
Thanks for posting your question.
For your reference:
C- Create, R- Run, U- Update, D-Delete
So if you want to permit the user to Update then you need to choose U, otherwise just tick R to Run.
See how you go with it.
Please let me know if you have any other question.
Regards,
Mahe
Hi Mahe,
It is clear now, we will discuss with our PO for the best choosing.
Thanks,
Jessica
From: Yellowfin Support [mailto:support@yellowfin.bi]
Sent: Monday, October 9, 2017 1:49 PM
To: Tian, Jessica <chunhua.tian@kodak.com>
Subject: New Comment in "How to set the permission for 'Database Views' to create data source and views?"
CAUTION: This email originated from outside of Kodak. Do not click links or open attachments unless you recognize the sender and know the content is safe.
Hi Mahe,
It is clear now, we will discuss with our PO for the best choosing.
Thanks,
Jessica
From: Yellowfin Support [mailto:support@yellowfin.bi]
Sent: Monday, October 9, 2017 1:49 PM
To: Tian, Jessica <chunhua.tian@kodak.com>
Subject: New Comment in "How to set the permission for 'Database Views' to create data source and views?"
CAUTION: This email originated from outside of Kodak. Do not click links or open attachments unless you recognize the sender and know the content is safe.
Hi Jessica,
Thanks for your reply.
I will mark this ticket as answered.
Let me know if you have any other questions.
Regards,
Mahe
Hi Jessica,
Thanks for your reply.
I will mark this ticket as answered.
Let me know if you have any other questions.
Regards,
Mahe
Hi Jessica,
Can you please let me know what version and build of Yellowfin you are running?
Also please send me some screenshots, I will try to replicate the issue you are facing and see if it is fixed in the latest builds or not, otherwise I will raise a defect.
Please let me know if you have any questions.
Regards,
Mahe
Hi Jessica,
Can you please let me know what version and build of Yellowfin you are running?
Also please send me some screenshots, I will try to replicate the issue you are facing and see if it is fixed in the latest builds or not, otherwise I will raise a defect.
Please let me know if you have any questions.
Regards,
Mahe
Hi Mahe,
Thanks very much for your quick response!
I created another ticket for this issue last week, and Ryan is working on it currently.
The problem I encountered is OK now after I restart yellowfin VMs.
One more question:
After investigated deeply, I found that: to make a role has the permission to create ‘Data Source’, it needs to select ‘C’(‘R’ is selected by default); if only select ‘U’, user with this role cannot create ‘Data Source’; is it the expected result?
If yes, then the limited requirement to make a role to have the permission to create ‘Data Source’ is select ‘C’(‘R’ is selected by default) only, is it right?
Please correct me if I misunderstood.
Thanks,
Jessica
From: Yellowfin Support [mailto:support@yellowfin.bi]
Sent: Monday, October 30, 2017 2:27 PM
To: Tian, Jessica <chunhua.tian@kodak.com>
Subject: New Comment in "How to set the permission for 'Database Views' to create data source and views?"
CAUTION: This email originated from outside of Kodak. Do not click links or open attachments unless you recognize the sender and know the content is safe.
Hi Mahe,
Thanks very much for your quick response!
I created another ticket for this issue last week, and Ryan is working on it currently.
The problem I encountered is OK now after I restart yellowfin VMs.
One more question:
After investigated deeply, I found that: to make a role has the permission to create ‘Data Source’, it needs to select ‘C’(‘R’ is selected by default); if only select ‘U’, user with this role cannot create ‘Data Source’; is it the expected result?
If yes, then the limited requirement to make a role to have the permission to create ‘Data Source’ is select ‘C’(‘R’ is selected by default) only, is it right?
Please correct me if I misunderstood.
Thanks,
Jessica
From: Yellowfin Support [mailto:support@yellowfin.bi]
Sent: Monday, October 30, 2017 2:27 PM
To: Tian, Jessica <chunhua.tian@kodak.com>
Subject: New Comment in "How to set the permission for 'Database Views' to create data source and views?"
CAUTION: This email originated from outside of Kodak. Do not click links or open attachments unless you recognize the sender and know the content is safe.
Hi Jessica,
Yes, you are correct, in order to create a Data source, the role needs to have "C" selected. and Yes, "R" is selected by default.
I have tested this on Ver 7.2, Build: 20161024 build.
Please let me know if you have any questions.
Regards,
Mahe
Hi Jessica,
Yes, you are correct, in order to create a Data source, the role needs to have "C" selected. and Yes, "R" is selected by default.
I have tested this on Ver 7.2, Build: 20161024 build.
Please let me know if you have any questions.
Regards,
Mahe
Hi Mahe,
I understand this function now, thanks very much for your help!
Best regards,
Jessica
From: Yellowfin Support [mailto:support@yellowfin.bi]
Sent: Tuesday, October 31, 2017 6:39 AM
To: Tian, Jessica <chunhua.tian@kodak.com>
Subject: New Comment in "How to set the permission for 'Database Views' to create data source and views?"
CAUTION: This email originated from outside of Kodak. Do not click links or open attachments unless you recognize the sender and know the content is safe.
Hi Mahe,
I understand this function now, thanks very much for your help!
Best regards,
Jessica
From: Yellowfin Support [mailto:support@yellowfin.bi]
Sent: Tuesday, October 31, 2017 6:39 AM
To: Tian, Jessica <chunhua.tian@kodak.com>
Subject: New Comment in "How to set the permission for 'Database Views' to create data source and views?"
CAUTION: This email originated from outside of Kodak. Do not click links or open attachments unless you recognize the sender and know the content is safe.
Thanks for your reply Jessica.
Regards,
Mahe
Thanks for your reply Jessica.
Regards,
Mahe
Replies have been locked on this page!