Revoke - database does not exist

From: Prashanth Kumar <prashanthk(at)hotmail(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Revoke - database does not exist
Date: 2014-05-02 00:49:09
Message-ID: BLU179-W127AF2C0D2C7150F6683B0CF430@phx.gbl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(at)ulinux3:~$ createuser -D -S -R -P testuser
Enter password for new role:
Enter it again:
postgres(at)ulinux3:~$ createdb myDB
postgres(at)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(at)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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tomáš Vondra 2014-05-02 01:02:08 Re: Revoke - database does not exist
Previous Message Prashanth Kumar 2014-05-02 00:38:44 Revoke Connect