Thread: 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.