Forum Discussion
Oracle Database Connection - Global Permissions
I am using a Oracle Database as my data source for my projects, but I'm having an issue with global permissions.
I use the same server for different projects, but with different user to auth with different permissions in Oracle DB.
For example:
Power BI Project 1
Server: Server01
User: user01
Power BI Project 2
Server: Server01
User: user02
But all my credentials are going to global permissions and being shared in both projects, even if I remove it from there.
When I change user01 in project 1, it changes my project 2 to user01 too.
In this scenario, I can get security problems because user01 couldn't see some data from user02.
What's the better way to avoid that? Is that possible? Am I doing something wrong?
Power BI Connection used: Oracle Database
Hi leandroxps ,
These two project are located in the same pbix file and have the same servername and database name, so the second connection will be created with the same credentials as the first.The proof is that you can only see one data source under Data Source Settings.
You'll have to make some changes to the connection to get around it. I'm assuming you're using the default port number, so with user02 you can use Server01:1521 to connect.
Best Regards,
Gao
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!How to get your questions answered quickly -- How to provide sample data in the Power BI Forum -- China Power BI User Group
3 Replies
Hi leandroxps ,
These two project are located in the same pbix file and have the same servername and database name, so the second connection will be created with the same credentials as the first.The proof is that you can only see one data source under Data Source Settings.
You'll have to make some changes to the connection to get around it. I'm assuming you're using the default port number, so with user02 you can use Server01:1521 to connect.
Best Regards,
Gao
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!How to get your questions answered quickly -- How to provide sample data in the Power BI Forum -- China Power BI User Group
It worked for me, thank you!
In time, my Power BI Desktop version is:
2.122.746.0 64-bit (October 2023)
I'm not using Power BI Service for those projects.
