MichaelB.
7/29/2018 - 6:55 PM

Find out ownership in system

Use these statements to find out who owns what

sql
content_copyfile_download
-- Find out ownership of catalog objects
SELECT * FROM OWNERSHIP where OWNER_NAME = ‘USER’ 
SELECT * FROM OWNERSHIP where OBJECT_NAME = ‘OBJECT_NAME’ 


-- Ownership of schemas
SELECT * FROM SCHEMAS where SCHEMA_NAME = ‘SCHEMA’ 
SELECT * FROM SCHEMAS where SCHEMA_OWNER = ‘USER’