Answers for "how to check someones permission on a redhisft external schema"

Whatever

0

how to check someones permission on a redhisft external schema

SELECT schemaname, objectname, usename,
       has_schema_privilege(usrs.usename, schemaname, 'usage')  AS usage
FROM(
    SELECT schemaname, tablename AS objectname, schemaname + '.' + tablename AS fullobj
    FROM SVV_EXTERNAL_TABLES
    ) AS objs,(SELECT * FROM pg_user) AS usrs

Posted by: Guest on February-24-2021

Source

Code answers related to "how to check someones permission on a redhisft external schema"

Code answers related to "Whatever"

Browse Popular Code Answers by Language

Python

Javascript

Whatever

Shell/Bash

CSS

Html

PHP

SQL

Java

C#