Hello,
I want to make a user that has read-only access to a database. I've read
the man pages on grant and revoke for table-level permissions, but I don't
see anything for database-level permissions on, say, creating tables or
views. Suppose I want to deny CREATE to some user. How does postgres do
this? I'm using 6.5.3-12 on debian linux.
I thought maybe I could fake it by doing a REVOKE on a system table (say,
pg_class or pg_tables) but that doesn't seem to work.
I have a suspicion that it may be unimplemented and planned for a future
version; http://www.postgresql.org/docs/todo.html says a planned
enhancement for admin is "More access control over who can create tables
and access the database". I'm hoping this is not the same as what I am
talking about, but thought someone here might know for certain. Thanks,
-kd
