Search Postgresql Archives

Re: Revoke - database does not exist

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



I guess you need to quote the identifier, as you use mixed case. I.e. try "myDB" with the double quotes.

Tomas

Dne 2. 5. 2014 2:49 Prashanth Kumar <prashanthk@xxxxxxxxxxx> napsal(a):
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


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux