Grand Permission
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...")
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