Denying CREATE TABLE capability
Denying CREATE TABLE capability
От:
"Michael Minock" <mjm@cs.umu.se>
Дата:
Hello all - My users are able to connect to a main database and then create their own databases. However I do not want them to be able to create tables in the main database. But in the main database, some users always create tables, which I have to periodically go in and drop. I have tried to deny users capability to add tables in the main database by revoking users rights on the catalog relations. Especially pg_class, etc... Still I have found no way to achieve the above policy. Does anyone know the trick to get this policy enforced? Thanks, Mike Minock
Re: Denying CREATE TABLE capability
От:
R D <mrk279@yahoo.com>
Дата:
Unfortunately There is no way atleast i do not know of such since you can not REVOKE this from users. I do not know why The developers consider this as not so inportant. This capability was in the todo list for 7.1 but was removed. I would like to see this feature in postgres because I'm tyred dropping unnecessary user tables. I'm also tired of hopeing to sse this and atlast I'll migrate to another RDBMS :). Rumen --- Michael Minock wrote: > Hello all - > > My users are able to connect to a main database and > then create their own > databases. > However I do not want them to be able to create > tables in the main database. > But in the main database, some users always create > tables, which I have to > periodically go in and drop. > > I have tried to deny users capability to add tables > in the main database by > revoking users rights on the catalog relations. > Especially pg_class, etc... Still I have found no > way to achieve the above > policy. > > Does anyone know the trick to get this policy > enforced? > > Thanks, > Mike Minock > > > ---------------------------(end of > broadcast)--------------------------- > TIP 6: Have you searched our list archives? > > http://www.postgresql.org/search.mpl __________________________________________________ Do You Yahoo!? Yahoo! Auctions - Buy the things you want at great prices. http://auctions.yahoo.com/