• 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;" 
    用一个例子来演示会更加清晰
  • 相关阅读:
    jquery插件-自定义select
    本地存储组件--兼容IE低版本
    jquery插件-省市联动
    nodejs学习笔记之包、模块实现
    nodejs学习笔记之安装、入门
    javascript的事件处理
    JS中简单的this学习
    你了解JS执行过程吗?
    halcon程序输出成c++程序
    poj3040
  • 原文地址:https://www.cnblogs.com/hixiaowei/p/15109401.html
Copyright © 2020-2023  润新知