jhjguxin

nginx 403 Forbidden Error hosting in User Home Directory

resources

• http://serverfault.com/questions/416787/nginx-403-forbidden-error-hosting-in-user-home-directory
• rails deploy with rvm, capistrano, uniron, nginx

runtime environment

oinopion

-- Create a group
CREATE ROLE readaccess;

-- Grant access to existing tables
GRANT USAGE ON SCHEMA public TO readaccess;
GRANT SELECT ON ALL TABLES IN SCHEMA public TO readaccess;

-- Grant access to future tables
ALTER DEFAULT PRIVILEGES IN SCHEMA public GRANT SELECT ON TABLES TO readaccess;