compartmentalizing users

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • jwsacksteder@ramprecision.com
    #1

    compartmentalizing users

    Is there a way to segregate users by database or schema so that in a hosting
    situation you could keep different customers apart? Otherwise, the
    unpleasant alternative is to run separate instances of Postgres.

    ---------------------------(end of broadcast)---------------------------
    TIP 4: Don't 'kill -9' the postmaster

    Tags: None
    • Bill Moran
      #2
      Re: compartmentaliz ing users

      jwsacksteder@ra mprecision.com wrote:[color=blue]
      > Is there a way to segregate users by database or schema so that in a hosting
      > situation you could keep different customers apart? Otherwise, the
      > unpleasant alternative is to run separate instances of Postgres.[/color]

      You can add users and assign rights at the database level.

      --
      Bill Moran
      Potential Technologies
      PotentialTech.com is for sale | HugeDomains
      http://www.potentialtech.com
      Short term financing makes it possible to acquire highly sought-after domains without the strain of upfront costs. Find your domain name today.



      ---------------------------(end of broadcast)---------------------------
      TIP 7: don't forget to increase your free space map settings

        Comment

        • Bruno Wolff III
          #3
          Re: compartmentaliz ing users

          On Fri, Feb 27, 2004 at 11:01:54 -0500,
          jwsacksteder@ra mprecision.com wrote:[color=blue]
          > Is there a way to segregate users by database or schema so that in a hosting
          > situation you could keep different customers apart? Otherwise, the
          > unpleasant alternative is to run separate instances of Postgres.[/color]

          Yes, but the separation isn't total. One solution would be to have a DB
          per user. However all users will still be able to see the shared
          system tables. This will allow them to see schema (DDL definitions)
          of other users. Though they won't be able to get at other user's
          data.

          ---------------------------(end of broadcast)---------------------------
          TIP 5: Have you checked our extensive FAQ?

          PostgreSQL: Not Found
          http://www.postgresql.org/docs/faqs/FAQ.html


            Comment

            • Bruce Momjian
              #4
              Re: compartmentaliz ing users

              Bruno Wolff III wrote:[color=blue]
              > On Fri, Feb 27, 2004 at 11:01:54 -0500,
              > jwsacksteder@ra mprecision.com wrote:[color=green]
              > > Is there a way to segregate users by database or schema so that in a hosting
              > > situation you could keep different customers apart? Otherwise, the
              > > unpleasant alternative is to run separate instances of Postgres.[/color]
              >
              > Yes, but the separation isn't total. One solution would be to have a DB
              > per user. However all users will still be able to see the shared
              > system tables. This will allow them to see schema (DDL definitions)
              > of other users. Though they won't be able to get at other user's
              > data.[/color]

              Take a look at the db_user_namespa ce option in postgresql.conf . It is
              used for this purpose.

              --
              Bruce Momjian | http://candle.pha.pa.us
              pgman@candle.ph a.pa.us | (610) 359-1001
              + If your life is a hard drive, | 13 Roberts Road
              + Christ can be your backup. | Newtown Square, Pennsylvania 19073

              ---------------------------(end of broadcast)---------------------------
              TIP 7: don't forget to increase your free space map settings

                Comment

                Previous template Next
                Working...