Re: Revoke - database does not exist

<p dir="ltr">I guess you need to quote the identifier, as you use mixed case. I.e. try "myDB" with the double quotes.<p
dir="ltr">Tomas<divclass="quote">Dne 2. 5. 2014 2:49 Prashanth Kumar <prashanthk@hotmail.com> napsal(a):<br
type="attribution"/><blockquote class="quote" style="margin:0 0 0 .8ex;border-left:1px #ccc
solid;padding-left:1ex"></blockquote></div><divdir="ltr">Hi,<br /><br />Do not seem to figure out what is wrong here.
Whyam I getting database does not exist.  I just created the database and am able to connect to it as "postgres"
user.<br/> I am trying to restrict  "testuser" from connecting to "myDB" database. <br /><br />Thanks in advance.<br
/><br/><br />postgres@ulinux3:~$ createuser -D -S -R -P testuser<br />Enter password for new role:<br />Enter it
again:<br/>postgres@ulinux3:~$ createdb myDB<br />postgres@ulinux3:~$ psql<br />psql (9.3.4)<br />Type "help" for
help.<br/><br />postgres=# REVOKE ALL PRIVILEGES  ON DATABASE myDB FROM testuser;<br />ERROR:  database "mydb" does not
exist<br/>postgres=# \q<br />postgres@ulinux3:~$ psql myDB<br />psql (9.3.4)<br />Type "help" for help.<br /><br
/>myDB=#REVOKE ALL PRIVILEGES  ON DATABASE myDB FROM testuser;<br />ERROR:  database "mydb" does not exist<br /><br
/><br/><br />--Prashanth Kumar<br /><br /></div>