Prevent users from creating tables

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Campano, Troy
    #1

    Prevent users from creating tables

    Hello,
    I'm trying to set up PostgreSQL for proof of concept according to our
    standards.
    I need to create a user for database01 that has the ability to create
    any objects they want.
    They can create tables, views, indexes, etc.

    Then I need a second user that has the privileges to only SELECT,
    INSERT, UPDATE, DELETE from objects in a certain database.

    How do I grant these privs?
    How do I prevent a user from dropping objects?

    Thank you!

    Troy Campano
    Liberty Mutual
    Infrastructure Software Engineering
    Database Management
    desk: (603) 245 4092
    cell: (603) 219 5539
    Department Information
    <http://intranet.lmig.com:3000/infosy...base/dbapp/dep
    artment/index.jsp>



    Tags: None
    • Jim Seymour
      #2
      Re: Prevent users from creating tables


      "Campano, Troy" <Troy.Campano@L ibertyMutual.co m> wrote:[color=blue]
      >
      > Hello,
      > I'm trying to set up PostgreSQL for proof of concept according to our
      > standards.
      > I need to create a user for database01 that has the ability to create
      > any objects they want.
      > They can create tables, views, indexes, etc.
      >
      > Then I need a second user that has the privileges to only SELECT,
      > INSERT, UPDATE, DELETE from objects in a certain database.
      >
      > How do I grant these privs?
      > How do I prevent a user from dropping objects?[/color]

      GRANT
      http://www.postgresql.org/docs/7.4/static/sql-grant.html


      Jim

      ---------------------------(end of broadcast)---------------------------
      TIP 3: if posting/reading through Usenet, please send an appropriate
      subscribe-nomail command to majordomo@postg resql.org so that your
      message can get through to the mailing list cleanly

        Comment

        • Jim Seymour
          #3
          Re: Prevent users from creating tables


          "Campano, Troy" <Troy.Campano@L ibertyMutual.co m> wrote:[color=blue]
          >
          > Hello,
          > I'm trying to set up PostgreSQL for proof of concept according to our
          > standards.
          > I need to create a user for database01 that has the ability to create
          > any objects they want.
          > They can create tables, views, indexes, etc.
          >
          > Then I need a second user that has the privileges to only SELECT,
          > INSERT, UPDATE, DELETE from objects in a certain database.
          >
          > How do I grant these privs?
          > How do I prevent a user from dropping objects?[/color]

          GRANT
          http://www.postgresql.org/docs/7.4/static/sql-grant.html


          Jim

          ---------------------------(end of broadcast)---------------------------
          TIP 3: if posting/reading through Usenet, please send an appropriate
          subscribe-nomail command to majordomo@postg resql.org so that your
          message can get through to the mailing list cleanly

            Comment

            Previous template Next
            Working...