question Postgres üzerinde kullanıcıya veritabanı erişim yetkilerini nasıl verebilirim?() {

1. // @author kenan | 27 Mayıs 2021

   [

   -- Çeşitli yetkilendirme örnekleri
   GRANT CONNECT ON DATABASE database_name TO username; 
   
   GRANT USAGE ON SCHEMA schema_name TO username; 
   
   GRANT SELECT, INSERT, UPDATE, DELETE ON ALL TABLES IN SCHEMA schema_name TO username; 
   
   GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA schema_name TO username; 
   
   GRANT ALL PRIVILEGES ON ALL SEQUENCES IN SCHEMA schema_name TO username; 
   
   GRANT ALL PRIVILEGES ON DATABASE database_name TO username; 
   
   --- sistem bazında yetkilendirme örnekleri
   ALTER USER username CREATEDB; 
   
   ALTER USER myuser WITH SUPERUSER; 
   
   ALTER USER username WITH NOSUPERUSER;
   

    

   ]

// Comments are closed.