Grand Permission
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