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

本文主要是介绍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;" 

这篇关于postgresql 新创建的库和表授权命令的文章就介绍到这儿，希望我们推荐的文章对大家有所帮助，也希望大家多多支持为之网！