Обсуждение: Permissions in PgSQL 7.2.1
Hi I have a problem with permissions. I have a user admin1. His permissions are select, insert, update and delete on table employee. After connecting with this user, I tried to create a table, and it worked. Why does this work? I don't want, that admin1 can create tables. Before I gave admin1 the permissions, I revoked all. Thanks for your answers. CU Roger
> I have a problem with permissions. I have a user admin1. His permissions are > select, insert, update and delete on table employee. > After connecting with this user, I tried to create a table, and it worked. > Why does this work? I don't want, that admin1 can create tables. > Before I gave admin1 the permissions, I revoked all. > Thanks for your answers. Everybody is able to create tables in recent releases and there is no way to stop them :). This is not good at all and this is one of the weaknesses of PgSQL. But we have the promise drom the developers that it will be fixed in version 7.3. Probably it will not be done in the best way but it will be better than nothing. regards, Hal __________________________________________________ Do You Yahoo!? Sign up for SBC Yahoo! Dial - First Month Free http://sbc.yahoo.com