Thread: Revoke - database does not exist
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
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
<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>
Prashanth Kumar wrote > 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. Thomas is likely correct about the quoting. The command programs are case-sensitive and perform the proper quoting for you when issuing commands; but when you are inside psql you need to take care to perform the proper quoting yourself. WRT grant/revoke keep in mind when you revoke you only remove pre-existing grants; it does not establish an explicit block on its own. i.e., it doesn't stop default permissions, or those inherited from PUBLIC, from applying. You would need to remove those inheritance-granted permissions and then explicitly grant them back to those who still require them while omitting those that do not. David J. -- View this message in context: http://postgresql.1045698.n5.nabble.com/Revoke-database-does-not-exist-tp5802183p5802185.html Sent from the PostgreSQL - general mailing list archive at Nabble.com.