1) This only query current database. I had written a query that inquire all databases. 2) Please remove schema='dbo' whereclause; otherwise you are only getting under schema dbo. 3) This query does not show roles inherited privilege, so you have to query again role permission.