smiley2211 escreveu:
Hello all,
I am using the query below to generate SQL code to grant access to objects -
how do I get this statement to PULL the fully qualified name
(schema.tablename)???
*****************
SELECT 'GRANT SELECT, INSERT, UPDATE, DELETE ON ' || relname ||
' TO newuser;'
FROM pg_class
where relname !~ 'pg_*' AND relkind in ('r','v','S') ORDER BY relname;
*****************
SELECT 'GRANT SELECT, INSERT, UPDATE, DELETE ON ' ||
pn.nspname || '.' || pc.relname ||' TO newuser;'
FROM pg_class pc JOIN pg_namespace pn
ON (pc.relnamespace = pn.oid)
WHERE pc.relname !~ 'pg_*' AND relkind in ('r','v','S')
AND pn.nspname != 'information_schema'
ORDER BY relname;
Osvaldo
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
