I am working on a SQL Server 2008 R2 database with 2 accounts
when i execute the following command SELECT * FROM fn_my_permissions('<<username>>','Database') it has Connect, Select, Execute and View Definition.
when i execute SELECT * FROM fn_my_permissions('<<username>>','Database') it has Connect - only.
When i use the low privilege account via Power BI interface, i get to connect, see the list of tables and when i select one to view data get an error "Expression error - id column of the table is not found"
I believe the above is for restricted permissions, however what's confusing is when i execute a select * from query on the table i get all the resulting data.
any one with more expertise, can you guide me to understand what is going on.