阿里云rds postgres回收用户权限
1,提工单由于当初设计都是用的public schema,而public schema对所有用户权限没有限制,所以需要回收部分用户的建表权限,=> dn List of schemas Name Owner public pg2490375 而public 默认owner是初始化实列的用户,所以提供单将public owner改成自己建的用户将test,template1数据库public schema的owner给xhc_test 。=> dn List of schemas Name Owner public xhc_test 2,若为rds_superuser 则改为nords_superuserxhc_dba=> alter user xhc_rw nords_superuser; 3,回收create 权限xhc_dba=> revoke create on schema public from public;xhc_dba=> c - xhc_rw;You are now connected to database "xhc_dba" as u...