写一段greenplum脚本授权schema

-- 授予用户对指定schema的访问权限 GRANT USAGE ON SCHEMA schema_name TO user_name;

-- 授予用户对指定schema下所有对象的操作权限 GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA schema_name TO user_name; GRANT ALL PRIVILEGES ON ALL SEQUENCES IN SCHEMA schema_name TO user_name; GRANT ALL PRIVILEGES ON ALL VIEWS IN SCHEMA schema_name TO user_name;

-- 可选：授予用户对指定schema下特定对象的操作权限 GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE table_name TO user_name; GRANT SELECT ON VIEW view_name TO user_name; GRANT USAGE, SELECT ON SEQUENCE sequence_name TO user_name;