<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>
<p dir="ltr">Tomas</p>
<div class="quote">Dne 2. 5. 2014 2:49 Prashanth Kumar <prashanthk(at)hotmail(dot)com> napsal(a):<br type='attribution'><blockquote class="quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><html>
<head>
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 12pt;
font-family:Calibri
}
--></style></head>
<body class='hmmessage'><div dir='ltr'>Hi,<br><br>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.<br> I am trying to restrict "testuser" from connecting to "myDB" database. <br><br>Thanks in advance.<br><br><br>postgres(at)ulinux3:~$ createuser -D -S -R -P testuser<br>Enter password for new role:<br>Enter it again:<br>postgres(at)ulinux3:~$ createdb myDB<br>postgres(at)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(at)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></body>
</html></blockquote></div>