Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
| user:nadir [2023/09/08 12:53] – nadir | user:nadir [2025/08/10 13:32] (current) – nadir | ||
|---|---|---|---|
| Line 489: | Line 489: | ||
| * Creates the Odoo database (if it was completely deleted) and restores the database backup. | * Creates the Odoo database (if it was completely deleted) and restores the database backup. | ||
| + | [[http:// | ||
| + | === GRANT ALL PREVILEGES TO A USER === | ||
| + | <cli> | ||
| + | GRANT USAGE ON SCHEMA public TO postgres; | ||
| + | GRANT SELECT ON ALL TABLES IN SCHEMA public TO postgres; | ||
| + | GRANT SELECT ON ALL SEQUENCES IN SCHEMA public TO postgres; | ||
| + | ALTER DEFAULT PRIVILEGES IN SCHEMA public GRANT SELECT ON TABLES TO postgres; | ||
| + | ALTER DEFAULT PRIVILEGES IN SCHEMA public GRANT SELECT ON SEQUENCES TO postgres; | ||
| + | </ | ||
| + | ===Command to Stop Spoofing Attacks === | ||
| + | <cli> | ||
| + | sudo iptables -A INPUT -p udp --dport 53 -m recent --name dns_flood --set | ||
| + | |||
| + | sudo iptables -A INPUT -p udp --dport 53 -m recent --name dns_flood --update --seconds 60 --hitcount 10 -j DROP | ||
| + | |||
| + | </ | ||
| + | this should limit the number of queries to 10 per second | ||