Hot answers tagged


You'd need to have select access on the specific table granted to you with the admin option GRANT SELECT ON <<table name>> TO dwhManager WITH ADMIN OPTION; That would need to be run for each table. You could do that in a loop with dynamic SQL BEGIN FOR t IN (SELECT * FROM dba_tables WHERE owner = <<...

Only top voted, non community-wiki answers of a minimum length are eligible