Thread: readonly acces to a db

readonly acces to a db

From
"Stefan Scherf"
Date:
Hi,

I have an user "tom" and a database "info". Now I want to allow tom to
connect to info, but he should only have read access (SELECT). This
especially means, that he should not be allowed to create tables or other
objects.

How can I manage this?

Greetings

Stefan


Re: readonly acces to a db

From
"Stefan Scherf"
Date:
> How about REVOKE ??

How can I use REVOKE to disallow a user to create a table?

Stefan