cevincheung

PostgreSQL 批量设置权限

  •  
  •   cevincheung · Jun 11, 2015 · 2891 views
    This topic created in 4065 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   ·   1564 Online   Highest 6679   ·     Select Language
    创意工作者们的社区
    World is powered by solitude
    VERSION: 3.9.8.5 · 45ms · UTC 16:36 · PVG 00:36 · LAX 09:36 · JFK 12:36
    ♥ Do have faith in what you're doing.