Peter Eisentraut wrote:
Pallav Kalva wrote:
I tried both database privileges and table privileges (all and
select) it still doesnt work. Not sure
what is wrong here, I tried logging in as both postgres and usps user
and both them doesnt work.
What about all those groups that have
usps=# revoke all on database usps from public,test;
You seem to think that that translates to revoking all privileges to
objects within the database. It doesn't. It only revokes privileges
directly associated with the database object, which are the rights to
create new schemas and temp tab
Peter Eisentraut wrote:
Pallav Kalva wrote:
Also here is the privileges information from information_schema
tables. Is there a way to REVOKE these
privileges ?
You need to log in as the user that has granted the privilege you want
to revoke. In this case, log in as postgres and do REVOKE
Tom Lane wrote:
Pallav Kalva <[EMAIL PROTECTED]> writes:
usps=> \z citystate_alias
Access privileges
for database "usps"
Schema | Table
|
Tom Lane wrote:
Pallav Kalva <[EMAIL PROTECTED]> writes:
I have a database for ex: 'ups' and it was owned previously by
'postgres(superuser)' but now i have changed the ownership to new user
'ups' all the tables are owned by these user 'ups'.
scott.marlowe wrote:
On Thu, 29 Apr 2004, Pallav Kalva wrote:
Hi ,
I am having some problems with setting up permissions in Postgres. I
have a database for ex: 'ups' and it was owned previously by
'postgres(superuser)' but now i have changed the ownership to new user
Hi ,
I am having some problems with setting up permissions in Postgres. I
have a database for ex: 'ups' and it was owned previously by
'postgres(superuser)' but now i have changed the ownership to new user
'ups' all the tables are owned by these user 'ups'. This database doesnt
have any sche
Hi,
I am new to postgres and I need to do a query which joins two tables
from different databases. Can you please advice me on how to achieve
this in postgres.
Thanks!
Pallav
---(end of broadcast)---
TIP 2: you can get off all lists at once wit
Hi,
I am new to postgres and I need to do a query which joins two tables
from different databases. Can you please advice me on how to achieve
this in postgres.
Thanks!
Pallav
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
