Re: [GENERAL] SELECT from other's tables

At 14:55 +0200 on 14/9/98, Sergei Chernev wrote:

> Hello,
> Sorry if it's FAQ but, how to select from smb's tables. So, I have an access
> to tables:
> bob=> grant all on AA to ser;
> CHANGE
> ser=>select * from aa;
> ERROR: aa: Table does not exist.

The other person has to connect to the same database.

What you did here is like this:

- Bob created (or was given) a database named bob.
- Ser created (or was given) a database named ser.
- Bob created a table AA in the database bob.
- Bob granted permission to Ser to access the table AA in database bob.
- Ser connects to database ser, looks for table AA, but there
is no such table in database ser. Only in database bob.

So, Ser should connect to database bob, by using "psql bob", not just "psql".

Herouth

--
Herouth Maoz, Internet developer.
Open University of Israel - Telem project
http://telem.openu.ac.il/~herutma