Apri Pebriana pebriana

pebriana / postgre_snippets.sql

Last active August 29, 2015 14:22 — forked from zmiftah/postgre_snippets.sql

	-- Grant For Schema
	GRANT ALL PRIVILEGES ON SCHEMA pdg TO project1;
	-- Grant For Table
	GRANT ALL PRIVILEGES ON TABLE pdg.proposal TO project1;
	-- Grant For Sequence
	GRANT USAGE, SELECT ON SEQUENCE pdg.proposal_id_seq TO project1;
	-- Grant For View
	GRANT SELECT ON pdg.vw_program_hierarchy TO project1;

	-- //-- Source: http://www.postgresql.org/docs/8.3/static/sql-grant.html --//