imported>Suraj: Created page with "Premission adding in server: SELECT 'GRANT ALL PRIVILEGES ON ' || relname || ' TO owrenchc_kwastep;' FROM pg_class JOIN pg_namespace ON pg_namespace.oid = pg_class.relname..."

2016-08-09T05:53:31Z

Created page with "Premission adding in server: SELECT 'GRANT ALL PRIVILEGES ON ' || relname || ' TO owrenchc_kwastep;' FROM pg_class JOIN pg_namespace ON pg_namespace.oid = pg_class.relname..."

New page

Premission adding in server:

SELECT 'GRANT ALL PRIVILEGES ON ' || relname || ' TO owrenchc_kwastep;'
FROM pg_class JOIN pg_namespace ON pg_namespace.oid = pg_class.relnamespace
WHERE nspname = 'public' AND relkind IN ('r', 'v')

SELECT 'GRANT ALL ON ' || quote_ident(schemaname) || '.' || quote_ident(relname) || ' TO owrenchc_kwastep;'
FROM pg_statio_all_sequences
WHERE schemaname = 'public';

After you get a Grand Query. Copy that Query and run again. Here "owrenchc_kwastep" is the user name

Grand Permission - Revision history

imported>Suraj: Created page with "Premission adding in server: SELECT 'GRANT ALL PRIVILEGES ON ' || relname || ' TO owrenchc_kwastep;' FROM pg_class JOIN pg_namespace ON pg_namespace.oid = pg_class.relname..."