From: | Kraus Philipp <philipp(dot)kraus(at)flashpixx(dot)de> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | acessibility for tables |
Date: | 2012-06-05 23:15:36 |
Message-ID: | 02A2609F-11DA-4E4B-ACB4-376235B9D99E@flashpixx.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hello,
I new on this mailing list and I need a little bit help for an idea to create different accesses to a database with Postgres 9.1.
I'm using this PG version at the time and I have created a database with a scheme "storage". Within this schema are some
tables, datatypes and stored procedure and each table has got a field "owner" with is filled with the current_user on insert.
The tables does not have any constraint to the pg system tables because the username need not to be null, so I use the
full character user name.
I don't want that any user can do something like "select * from storage.table". My target ist, that the user can only see
these datasets, which he/she is owned (the field owner must be equal to current_user). IMHO I have created some
view within the public scheme, so the user can select the datasets on this views, but I can't insert / update on views, so
I would like to write some procedure which can be updated and insert new data. So on this case my question is:
Can I suppress any access to the "storage" schema only the datbase itself should be do anything on it?
Is this a good idea to create this different access? Is there a better solution with postgres?
I would like to denied any access to all datasets which are not owned.
Thanks
Phil
From | Date | Subject | |
---|---|---|---|
Next Message | Rich Shepard | 2012-06-05 23:28:20 | Re: Populate Table From Two Other Tables |
Previous Message | Greg Williamson | 2012-06-05 23:02:28 | Re: Populate Table From Two Other Tables |