user:nadir

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision		 Previous revision
user:nadir [2023/12/27 11:35] – nadiruser:nadir [2025/08/10 13:32] (current) – nadir
Line 490: Line 490:
  
 [[http://babyshop-dz.com]] [[http://babyshop-dz.com]]
 +=== 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;
 +
 +</cli> 
    
 +===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
 +
 +</cli>
 +   this should limit the number of queries to 10 per second 
  
  
  
  
  • user/nadir.1703676926.txt.gz
  • Last modified: 2023/12/27 11:35
  • by nadir