|
Hi,
Do not seem to figure out what is wrong here. Why am I getting database does not exist. I just created the database and am able to connect to it as "postgres" user. I am trying to restrict "testuser" from connecting to "myDB" database. Thanks in advance. postgres@ulinux3:~$ createuser -D -S -R -P testuser Enter password for new role: Enter it again: postgres@ulinux3:~$ createdb myDB postgres@ulinux3:~$ psql psql (9.3.4) Type "help" for help. postgres=# REVOKE ALL PRIVILEGES ON DATABASE myDB FROM testuser; ERROR: database "mydb" does not exist postgres=# \q postgres@ulinux3:~$ psql myDB psql (9.3.4) Type "help" for help. myDB=# REVOKE ALL PRIVILEGES ON DATABASE myDB FROM testuser; ERROR: database "mydb" does not exist --Prashanth Kumar |
