Обсуждение: User rights across databases

Do user permissions exist accros databases?
I have two databases, one production one test, where I have tables with
the same names. I was going to add users to the test database and the
server responded that the users already existed. How are the permissions
controlled for tables with the same name accros different databases?

Users are global for all the databases.
Permissions apply to table ids, not to their names.



Francisco Reyes wrote:

>Do user permissions exist accros databases?
>I have two databases, one production one test, where I have tables with
>the same names. I was going to add users to the test database and the
>server responded that the users already existed. How are the permissions
>controlled for tables with the same name accros different databases?
>
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 6: Have you searched our list archives?
>
>http://archives.postgresql.org
>
>
>


--
Dado Feigenblatt                                 Wild Brain, Inc.
Technical Director                               (415) 216-2053
dado@wildbrain.com                               San Francisco, CA.

I was wandering through the source on how to send back multiple rows and
columns and stumbled apon ExprMultipleResult mentioned in the README in
src/backend/utils/fmgr/.  Unfortunately, I'm not sure if this is or is
not what I'm looking for.  There's very little code using this feature
and I could not find any documentation.  Can anyone explain to me if
this is what I need and, if so, how to implement it using Version 1
style coding as well as any other helpful pieces of information?

Geoff

Geoffrey J. Gowey wrote:

> I was wandering through the source on how to send back multiple rows and
> columns and stumbled apon ExprMultipleResult mentioned in the README in
> src/backend/utils/fmgr/.  Unfortunately, I'm not sure if this is or is
> not what I'm looking for.  There's very little code using this feature
> and I could not find any documentation.  Can anyone explain to me if
> this is what I need and, if so, how to implement it using Version 1
> style coding as well as any other helpful pieces of information?
>

You can return multiple rows, but not really multiple columns directly
(at least not yet). See contrib/dblink in the 7.2 beta for an example.

HTH,

--Joe

On Wed, 12 Dec 2001, Dado Feigenblatt wrote:

> Users are global for all the databases.
> Permissions apply to table ids, not to their names.

Thanks. So I guess groups are also global.