Forum Discussion
Read Only DB User
Hello, we are currently trying to use a Read Only PostgreSql user which has only credentials to select from a certain schema. When I connect to that schema with the Read Only user, Power BI c...
For people searching for such a solution in the future: It's detached from Power BI and related to the database. We know extend the privileges by REFERENCES, so the user can do nothing except SELECT and REFERENCES and since he doesn't own a table or something else, a foreign key cannot be created. So he has the right to REFERENCE, but cannot use it at all.
For people searching for such a solution in the future: It's detached from Power BI and related to the database. We know extend the privileges by REFERENCES, so the user can do nothing except SELECT and REFERENCES and since he doesn't own a table or something else, a foreign key cannot be created. So he has the right to REFERENCE, but cannot use it at all.