February 14, 2023 - BYNATREE DATA SOLUTIONS

Feb142023

IDENTIFY A ROLE HAS EXECUTE PERMISSION ON FUNCTION IN POSTGRESQL

PostgresqlFebruary 14, 2023 Leave a comment

IDENTIFY A ROLE HAS EXECUTE PERMISSION ON FUNCTION IN POSTGRESQL To identify a role has execute permission on function, PostgreSQL has a catalog function(has_function_privilege) which makes…

Read article

Feb142023

REMAP_SCHEMA IN POSTGRESQL

LinuxFebruary 14, 2023 Leave a comment

This is very typical requirement we get in DBA world where we need to copy tables from one schema to another schema. In Oracle we…

Read article

Daily Archives: February 14, 2023

IDENTIFY A ROLE HAS EXECUTE PERMISSION ON FUNCTION IN POSTGRESQL

REMAP_SCHEMA IN POSTGRESQL