The following bug has been logged online:
Bug reference: 3411
Logged by:
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.0.13
Operating system: XP SP2
Description:how to add the granted of "Log on as a service"
Details:
When I start the sevice,the account "p
I try to revoke create privileges (PG8.2.4) on the default tablespace and I
found following strange behavior:
As superuser:
revoke create on TABLESPACE pg_default from u_test1;
As u_test1:
ns_test=> create table test_06 (id int) tablespace pg_default;
ERROR: permission deni
Zdenek Kotala <[EMAIL PROTECTED]> writes:
> It seems that we not able to revoke create privilege on default tablespace.
This is intentional.
regards, tom lane
---(end of broadcast)---
TIP 5: don't forget to increase your fre
Tom Lane wrote:
Zdenek Kotala <[EMAIL PROTECTED]> writes:
It seems that we not able to revoke create privilege on default tablespace.
This is intentional.
I don't understand why. I did not find any mention about this in the
documentation. Please, could you explain it?
Than
Zdenek Kotala <[EMAIL PROTECTED]> writes:
> Tom Lane wrote:
>> Zdenek Kotala <[EMAIL PROTECTED]> writes:
>>> It seems that we not able to revoke create privilege on default tablespace.
>>
>> This is intentional.
> I don't understand why.
It's presumed that the right to create tables within a dat
Tom Lane wrote:
Zdenek Kotala <[EMAIL PROTECTED]> writes:
Tom Lane wrote:
Zdenek Kotala <[EMAIL PROTECTED]> writes:
It seems that we not able to revoke create privilege on default tablespace.
This is intentional.
I don't understand why.
It's presumed that the right to create tables withi
Zdenek Kotala <[EMAIL PROTECTED]> writes:
> Tom Lane wrote:
>> It's presumed that the right to create tables within a database entails
>> the right to create them someplace; hence no permissions check is made
>> on the database's default tablespace. Without that, not only does plain
>> CREATE TABL
