PROBLEM: We have granted select privilege on one table of a schema to another user. Even after that the user was getting permission denied error while selecting data. — Privilege was granted like this PRIMDB=# grant all privileges on table SCOTT.SERVER_LOAD_INFO to prim_user; GRANT Now connect to prim_user and run the select statement: psql -d […]

There are multiple ways to drop a database in postgres . DEMO: In this article, we will drop the database named: DBACLASS. postgres=# \list List of databases Name | Owner | Encoding | Collate | Ctype | Access privileges ———–+———-+———-+———+——-+———————– DBACLASS | postgres | UTF8 | C | C | — >>>>>>> THIS ONE postgres […]

In this tutorial, i have explained steps for installing EDB postgres database on macos. The steps are similar for linux system also. It will be a GUI method.   Download the software:   Link – > https://www.enterprisedb.com/downloads/postgres-postgresql-downloads   Download the executable according to your platform.         2. Start the downloaded executable:     Now […]