Обсуждение: readonly acces to a db

Поиск
Список
Период
Сортировка

readonly acces to a db

От
"Stefan Scherf"
Дата:
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

От
"Stefan Scherf"
Дата:
> How about REVOKE ??

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

Stefan