Home / server / Questions / 184367
Accepted
Woot4Moo
Asked: 2010-09-25 08:08:46 +0800 CST

How to deny create function to user on PostgreSQL?

  • 772

How does one go about explicitly denying the create function ability of a non superuser in postgres? I looked into the documentation, but was unable to find anything of value.

postgresql

1 Answers

  1. Best Answer

    You can look here for the documentation. You would use the Revoke command in place of grant and just specify Create.

    REVOKE { { CREATE | TEMPORARY | TEMP } [,...] | ALL [ PRIVILEGES ] }
ON DATABASE dbname [, ...]
TO { username | GROUP groupname | PUBLIC } [, ...]

    EDIT:

    Here is where you go for Revoke, which has more options.

    REVOKE [ GRANT OPTION FOR ]
{ EXECUTE | ALL [ PRIVILEGES ] }
ON FUNCTION funcname ( [ [ argmode ] [ argname ] argtype [, ...] ] ) [, ...]
FROM { username | GROUP groupname | PUBLIC } [, ...]
[ CASCADE | RESTRICT ]
    • 2