question on the information_schema

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

 



Hi all,
I created a database named "test" with the user "postgres" and I have given all privileges on database "test" to a user that I use daily, called "ssaa".
By submitting, as user "ssaa", to "test" database the «select * from information_schema.columns with where col.table_schema! = 'Pg_catalog' and col.table_schema! = 'Information_schema'» query, instead of the list of columns, I have an empty table. I have to give some special permit ssaa user?

How do I resolve?
Thanks.

Ps. I apologize for my poor english.



[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux