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
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 |