Обсуждение: SELECT from other's tables

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.

Thanx.
---------------------------
Sergei Chernev
Internet: ser@nsu.ru
Phone: +7-3832-397354

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