Admin and tuningPostgreSQL
ALTER ROLE
ALTER ROLEGRANTManage access control for users and roles.
Command
ALTER ROLE WITH LOGIN PASSWORD '';
Example usage
Set role authentication and grant permissions over schemas.
ALTER ROLE <role> WITH LOGIN PASSWORD '<password>';GRANT SELECT ON ALL TABLES IN SCHEMA public TO <role>;Related tags
Admin and tuningGRANTdatabasesqlpsql