How to set the permission for 'Database Views' to create data source and views?

jessica shared this question 2 years ago
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

Comments (8)

photo
1

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

photo
1

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.

photo
1

Hi Jessica,

Thanks for your reply.

I will mark this ticket as answered.

Let me know if you have any other questions.

Regards,

Mahe

photo
1

Seems I misunderstood it, I will investigate it more.

photo
photo
1

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

photo
1

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.

photo
1

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

photo
1

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.

photo
1

Thanks for your reply Jessica.

Regards,

Mahe