subject:"\[SQL\] Accessing objects over db\-borders"

Re: [despammed] [SQL] Accessing objects over db-borders

2005-02-04 Thread Andreas Kretschmer

am 04.02.2005, um 12:00:17 +0100 mailte KÖPFERL Robert folgendes: > Hi, > > Consider one postmaster that manages multiple databases (logical names) > > Is it possible (and how) to access a stored procedure or view/Table which > resides in DB aaa if your DB-connection has currently the context on

[SQL] Accessing objects over db-borders

2005-02-04 Thread KÖPFERL Robert

Hi, Consider one postmaster that manages multiple databases (logical names) Is it possible (and how) to access a stored procedure or view/Table which resides in DB aaa if your DB-connection has currently the context on DB bbb? So: I login on db bbb as a user who has rights on both DBs (aaa,bbb).