Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2003
    Posts
    2

    Unanswered: how to grant dba to user

    i know how to grant object to one user ,
    but if i want to grant dba privilege to one user.
    how to ??
    for example:
    i have two user : u1,u2,
    u1 create db scp1.
    now i want the u2 can use all tables in scp1,
    how to ?
    i don't want to grant hundreds of times to grant table privilge
    to u2.

  2. #2
    Join Date
    Sep 2001
    Location
    Vienna
    Posts
    400

    grant

    test=# \h grant
    Command: GRANT
    Description: define access privileges
    Syntax:
    GRANT { { SELECT | INSERT | UPDATE | DELETE | RULE | REFERENCES | TRIGGER }
    [,...] | ALL [ PRIVILEGES ] }
    ON [ TABLE ] tablename [, ...]
    TO { username | GROUP groupname | PUBLIC } [, ...]

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

    ------------
    I think this is what you mean
    use the \h in postgres
    it's really good
    ------------

    GRANT { EXECUTE | ALL [ PRIVILEGES ] }
    ON FUNCTION funcname ([type, ...]) [, ...]
    TO { username | GROUP groupname | PUBLIC } [, ...]

    GRANT { USAGE | ALL [ PRIVILEGES ] }
    ON LANGUAGE langname [, ...]
    TO { username | GROUP groupname | PUBLIC } [, ...]

    GRANT { { CREATE | USAGE } [,...] | ALL [ PRIVILEGES ] }
    ON SCHEMA schemaname [, ...]
    TO { username | GROUP groupname | PUBLIC } [, ...]
    http://www.postgresql.org
    --Postgresql is the only kind of thing--

Posting Permissions

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