postgresql 新创建的库和表授权命令

1. postgresql 新创建的库和表授权命令

*/20 * * * * /usr/bin/psql -d  tenant_1011046 -q -t -c "GRANT SELECT ON ALL TABLES IN SCHEMA public TO liujunfan;" 
*/20 * * * * /usr/bin/psql -d  tenant_1011046 -q -t -c "GRANT SELECT ON ALL TABLES IN SCHEMA public TO caoxingquan;" 
*/20 * * * * /usr/bin/psql -d  tenant_1011046 -q -t -c "GRANT SELECT ON ALL TABLES IN SCHEMA public TO gukaiwei;" 
*/20 * * * * /usr/bin/psql -d  tenant_1011046 -q -t -c "GRANT SELECT ON ALL TABLES IN SCHEMA public TO huangpeisi;" 
*/20 * * * * /usr/bin/psql -d  tenant_1011046 -q -t -c "GRANT SELECT ON ALL TABLES IN SCHEMA public TO huangrixiong;" 
*/20 * * * * /usr/bin/psql -d  tenant_1011046 -q -t -c "GRANT SELECT ON ALL TABLES IN SCHEMA public TO liujiahao;" 
*/20 * * * * /usr/bin/psql -d  tenant_1011046 -q -t -c "GRANT SELECT ON ALL TABLES IN SCHEMA public TO ouyuanhui;" 
*/20 * * * * /usr/bin/psql -d  tenant_1011046 -q -t -c "GRANT SELECT ON ALL TABLES IN SCHEMA public TO liujiahao;" 
*/20 * * * * /usr/bin/psql -d  tenant_1011046 -q -t -c "GRANT SELECT ON ALL TABLES IN SCHEMA public TO yebowei;" 
*/20 * * * * /usr/bin/psql -d  tenant_1011046 -q -t -c "GRANT SELECT ON ALL TABLES IN SCHEMA public TO xiejun;" 

 

上一篇:jmeter之Ramp-up Period(in seconds)


下一篇:第一天