cevincheung

PostgreSQL 批量设置权限

  •  
  •   cevincheung · Jun 11, 2015 · 2881 views
    This topic created in 4058 days ago, the information mentioned may be changed or developed.

    场景:
    superuser postgres创建了一个库data
    然后又创建了一个普通用户user
    grant all on table to user一次只能授权一个表
    批量设置权限:
    grant all on all tables in schema to user

    No Comments Yet
    About   ·   Help   ·   Advertise   ·   Blog   ·   API   ·   FAQ   ·   Solana   ·   5780 Online   Highest 6679   ·     Select Language
    创意工作者们的社区
    World is powered by solitude
    VERSION: 3.9.8.5 · 26ms · UTC 02:47 · PVG 10:47 · LAX 19:47 · JFK 22:47
    ♥ Do have faith in what you're doing.