Hi Howard,
Il giorno mer, 13/07/2011 alle 23.30 +0100, Howard Cole ha scritto:
> Hi Guiseppe,
>
> Perhaps you can create a trigger that monitors for the insertion of an
> oid and then grant permissions. No idea if this can be done, but if it
> can it will save you lots of repeated grants.
[...]
On Wed, 2011-07-13 at 23:30 +0100, Howard Cole wrote:
> On 13/07/2011 8:15 PM, Giuseppe Sacco wrote:
> >
> > Is there any other possibility?
>
> Hi Guiseppe,
>
> Perhaps you can create a trigger that monitors for the insertion of an
> oid and then grant permissions. No idea if this can be done,
On 13/07/2011 8:15 PM, Giuseppe Sacco wrote:
Is there any other possibility?
Hi Guiseppe,
Perhaps you can create a trigger that monitors for the insertion of an
oid and then grant permissions. No idea if this can be done, but if it
can it will save you lots of repeated grants.
An easier o
Hi Howard,
Il giorno mer, 13/07/2011 alle 13.18 +0100, Howard Cole ha scritto:
[...]
> As an interim solution, you could set the large object compatibility:
>
> www.postgresql.org/docs/9.0/interactive/runtime-config-compatible.html#GUC-LO-COMPAT-PRIVILEGES
thanks for pointing to this option. I a
On 13/07/2011 8:49 AM, Giuseppe Sacco wrote:
Hi all,
I moved a few clusters from 8.4 to 9.0 since I required the new way of
authenticating against LDAP (or, in my case, AD). Now, I found the new
database version introduced permissions on large object, so my
application, in order to share large ob
Hi all,
I moved a few clusters from 8.4 to 9.0 since I required the new way of
authenticating against LDAP (or, in my case, AD). Now, I found the new
database version introduced permissions on large object, so my
application, in order to share large object across a group, require a
bit of change.
Henriksen, Jonas F wrote:
Hi,
how come, if you create a user with no permissions at all, having
been granted nothing, he can still log into any database, list
available tables, create new here, and then delete them again. Seems
odd...:
Is this right, or is there something wrong with my settings in
Hi,
how come, if you create a user with no permissions at all, having been granted
nothing, he can still log into any database, list available tables, create new here,
and then delete them again. Seems odd...:
medusa:~% createuser odd
Shall the new user be allowed to create databases? (y/n) n
