Re: [BUGS] REVOKE CREATE does not work on default tablespace

2007-06-26 Thread Tom Lane
Zdenek Kotala <[EMAIL PROTECTED]> writes: > I still does not see any benefit from user side why postgres has this > exception. It is confusing and it should generate potential security > risk. "Security risk"? Now you're just making things up. regards, tom lane

Re: [BUGS] REVOKE CREATE does not work on default tablespace

2007-06-26 Thread Zdenek Kotala
Tom Lane wrote: 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 CREAT

Re: [BUGS] REVOKE CREATE does not work on default tablespace

2007-06-25 Thread Tom Lane
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

Re: [BUGS] REVOKE CREATE does not work on default tablespace

2007-06-25 Thread Zdenek Kotala
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

Re: [BUGS] REVOKE CREATE does not work on default tablespace

2007-06-25 Thread Tom Lane
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

Re: [BUGS] REVOKE CREATE does not work on default tablespace

2007-06-25 Thread Zdenek Kotala
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

Re: [BUGS] REVOKE CREATE does not work on default tablespace

2007-06-25 Thread Tom Lane
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