Professional Web Applications Themes

Privileges question - PostgreSQL / PGSQL

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hello, ~ I created a schema, database, tables, users and a user group. create user sma_user password 'xx'; create group sma_user_group; alter group sma_user_group add user sma_user; create table sma_apps.ordr_dat ( ... ); grant select,delete,insert,update on sma_apps.ordr_dat to group sma_user_group; ~ Access privileges for database "smadb1" ~ Schema | Name | Type | Access privileges - ----------+----------+-------+--------------------------------------------------------------------- ~ sma_apps | ordr_dat | table | {sma_admin=arwdRxt/sma_admin,"group sma_user_group=arwd/sma_admin"} ~ When logged in as sma_user, it is denied access to the schema: ERROR: permission denied for schema sma_apps What am I missing? How do I provide access ...

  1. #1

    Default Privileges question

    -----BEGIN PGP SIGNED MESSAGE-----
    Hash: SHA1

    Hello,
    ~ I created a schema, database, tables, users and a user group.

    create user sma_user password 'xx';
    create group sma_user_group;
    alter group sma_user_group add user sma_user;

    create table sma_apps.ordr_dat ( ... );
    grant select,delete,insert,update on sma_apps.ordr_dat to group
    sma_user_group;

    ~ Access privileges for database "smadb1"
    ~ Schema | Name | Type | Access privileges
    -
    ----------+----------+-------+---------------------------------------------------------------------
    ~ sma_apps | ordr_dat | table | {sma_admin=arwdRxt/sma_admin,"group
    sma_user_group=arwd/sma_admin"}


    ~ When logged in as sma_user, it is denied access to the schema:
    ERROR: permission denied for schema sma_apps

    What am I missing? How do I provide access to a schema?

    - --
    jimoe at sohnen-moe dot com
    -----BEGIN PGP SIGNATURE-----
    Version: GnuPG v1.4.0 (OS/2)
    Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

    iD8DBQFCEPUUzTcr8Prq0ZMRAvU/AJ90kwdpxNYGgHdzBA7A2uPFo4FcNwCdFeGz
    Q7Dte87qrtET8yoI7uZ9VD0=
    =0sLa
    -----END PGP SIGNATURE-----

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

    http://www.postgresql.org/docs/faq

    James Guest

  2. #2

    Default Re: Privileges question

    On Mon, Feb 14, 2005 at 11:59:33AM -0700, James Moe wrote: 

    See "Schemas and Privileges" in the doentation, as well as the
    doentation for GRANT:

    http://www.postgresql.org/docs/8.0/static/ddl-schemas.html#DDL-SCHEMAS-PRIV
    http://www.postgresql.org/docs/8.0/static/sql-grant.html

    --
    Michael Fuhr
    http://www.fuhr.org/~mfuhr/

    ---------------------------(end of broadcast)---------------------------
    TIP 8: explain yze is your friend

    Michael Guest

  3. #3

    Default Re: Privileges question


    James --

    I am not sure if anyone answered this yet, but you might try:
    GRANT USAGE ON SCHEMA sma_apps TO sma_user;
    as the same user as createdthe schema ...

    HTH,

    Greg Williamson
    DBA
    GlobeXplorer LLC
    -----Original Message-----
    From: James Moe [mailto:com]
    Sent: Mon 2/14/2005 10:59 AM
    To: org
    Cc:
    Subject: [GENERAL] Privileges question
    -----BEGIN PGP SIGNED MESSAGE-----
    Hash: SHA1

    Hello,
    ~ I created a schema, database, tables, users and a user group.

    create user sma_user password 'xx';
    create group sma_user_group;
    alter group sma_user_group add user sma_user;

    create table sma_apps.ordr_dat ( ... );
    grant select,delete,insert,update on sma_apps.ordr_dat to group
    sma_user_group;

    ~ Access privileges for database "smadb1"
    ~ Schema | Name | Type | Access privileges
    -
    ----------+----------+-------+---------------------------------------------------------------------
    ~ sma_apps | ordr_dat | table | {sma_admin=arwdRxt/sma_admin,"group
    sma_user_group=arwd/sma_admin"}


    ~ When logged in as sma_user, it is denied access to the schema:
    ERROR: permission denied for schema sma_apps

    What am I missing? How do I provide access to a schema?

    - --
    jimoe at sohnen-moe dot com
    -----BEGIN PGP SIGNATURE-----
    Version: GnuPG v1.4.0 (OS/2)
    Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

    iD8DBQFCEPUUzTcr8Prq0ZMRAvU/AJ90kwdpxNYGgHdzBA7A2uPFo4FcNwCdFeGz
    Q7Dte87qrtET8yoI7uZ9VD0=
    =0sLa
    -----END PGP SIGNATURE-----

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

    http://www.postgresql.org/docs/faq

    !DSPAM:4210f76918377043564807!





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

    Gregory Guest

Similar Threads

  1. adminstrator privileges
    By kygirl74 in forum Macromedia Shockwave
    Replies: 2
    Last Post: December 4th, 07:37 PM
  2. Replies: 4
    Last Post: August 23rd, 02:08 PM
  3. User Privileges
    By RG in forum Windows Server
    Replies: 1
    Last Post: June 2nd, 06:26 PM
  4. No Grant Privileges
    By Marc in forum PHP Development
    Replies: 3
    Last Post: January 4th, 11:49 AM
  5. Security Privileges,NEED HELP
    By Lynn in forum Windows Setup, Administration & Security
    Replies: 0
    Last Post: July 1st, 08:14 PM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139