If I understand correctly you are suggesting that I need to reverse my direction of inquiry.
currently i use a line like this one :
- select * from sys.database_permissions join sys.database_principals on grantee_principal_id = principal_id where major_id='1611152785'
to get the roles and users associated with an object
Instead of trying to read the roles of a particular object using the object ID, I should instead read the user and then read which permissions that user has for that object ?
Can i also use the same line of logic for roles ?
The interface in MS SQL SERVER management studio does not make clear the object permission are are children of the user rather then the object . It seems to imply the reverse . Am i reading wrong ?