SQL: How to Know / Query current Schema Privileges

If you are connected from desired schema to the database, run below query to know its granted privileges:

SELECT * FROM SESSION_PRIVS;