Grand Permission

From Origami_Wiki
Revision as of 11:23, 9 August 2016 by 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...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

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