Definitions More Info.
Definition ID	4.035
Title	POSTGRESQL
Category	NOTES
Definition	role kullanici erisimini permssion database veritabanindan engelleme
Definition Description	https://www.dbrnd.com/2016/08/postgresql-why-new-user-can-access-all-databases-without-any-grants-revoke-connect-permission/ REVOKE CONNECT privileges from Database: ========================================== REVOKE CONNECT ON DATABASE Database_Name FROM User_Name; REVOKE all privileges from Database: ------------------------------------- REVOKE ALL PRIVILEGES ON DATABASE Database_Name FROM User_Name; OR: REVOKE ALL PRIVILEGES ON DATABASE "IYS" FROM testkubernetes_iys; You should GRANT only required Databases: ------------------------------------------- GRANT CONNECT ON DATABASE Database_Name TO User_Name;
RecordBy	cunay
Record Date	11-11-2020 16:05:41
Düzenle
Kopyala
Sil