1

When I run query:

SELECT table_catalog, table_schema, table_name, privilege_type
FROM   information_schema.table_privileges 
WHERE  grantee = (select user)

This shows only those tables (with all privileges), which I (current user) created on this DB, There are lots of another tables (created by another users), where I can succesfully ran UPDATE or DELETE commands for example, though those tables are not shown by above query.

I though that query is way, to check user priveleges for each tables. but seems thats not quite correct? please tell me where I'm wrong ?

oh no
  • 49
  • 1
  • 9

0 Answers0