我不知道如何给每一个特定用户的权利,我希望用户在模式上拥有每一个权利:
>在现有表上插入,删除,更新,选择…
我试过:
GRANT ALL PRIVILEGES ON SCHEMA schema to "user"; GRANT ALL ON SCHEMA schema to "local_518561"; GRANT ALL PRIVILEGES ON table schema.table to "user"; GRANT ALL ON table schema.table to "user";
GRANT ALL PRIVILEGES ON SCHEMA schema_name TO role_name; GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA schema_name TO role_name; GRANT ALL PRIVILEGES ON ALL SEQUENCES IN SCHEMA schema_name TO role_name;