Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2016
    Posts
    5

    Unanswered: revoke rights to create table.

    is it possible to revoke the right to create a table from a role?
    the role has right to insert and select. but it shall not be allowed to create the table because then it becomes owner of the table. As owner it can update and delete.

  2. #2
    Join Date
    Nov 2003
    Posts
    2,915
    Provided Answers: 8
    You need to revoke that privilege from the schema:
    Code:
    revoke create on schema public from the_role;
    You probably also want to revoke the right to create new schemas:
    Code:
    revoke create on database from the_role;
    I will not read nor answer questions where the SQL code is messy and not formatted properly using [code] tags: http://www.dbforums.com/misc.php?do=bbcode#code

    Tips for good questions:

    http://tkyte.blogspot.de/2005/06/how...questions.html
    http://wiki.postgresql.org/wiki/SlowQueryQuestions
    http://catb.org/esr/faqs/smart-questions.html

  3. #3
    Join Date
    Jun 2016
    Posts
    5
    REVOKE ALL ON SCHEMA public FROM PUBLIC; (works)

    works, but not if I revoke only on users I created.
    REVOKE ALL ON SCHEMA public FROM myuser; (doesn't work)

    This is strange.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •