Grand Permission

From Origami_Wiki
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