cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Reply
prapatsorn
Regular Visitor

Not respecting Oracle database authorizations

‎11-02-2022 02:50 AM

Hi all,

 

I just found out that Power BI desktop is not respecting the Oracle database authorizations. The login should be able to pull data from only its own schema, but I have tried pulling data from other schemas and it all retrieved successfully. I don't think this scenario is supposed to happen, any ideas?

 

Thanks!

Labels:
Message 1 of 3
118 Views
0
1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

‎11-02-2022 02:57 AM

@prapatsorn , I think the user might have access or may be an admin. I doubt Oracle will allow access outside what is allowed



View solution in original post

Message 2 of 3
110 Views
2 REPLIES 2
amitchandak
Super User
Super User

‎11-02-2022 02:57 AM

@prapatsorn , I think the user might have access or may be an admin. I doubt Oracle will allow access outside what is allowed



Message 2 of 3
111 Views
prapatsorn
Regular Visitor
In response to amitchandak

‎11-07-2022 12:09 AM

Yeah, so upon further inspection I was wrong. It had authorization for all schemas, I'll probably create another login for this specific purpose. Thanks though

Message 3 of 3
52 Views
0

Helpful resources

Announcements
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

View All
Top Solution Authors
View All