Обсуждение: SELECT privilege to a DATABASE

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

SELECT privilege to a DATABASE

От
Abhijit Gharami
Дата:
Hi,

How can we provide only SELECT privilege on all the table in a DATABASE to a user. I checked the documents and found that it is possible in schema level of a database.

Thanks and Regards,
Abhijit

Re: SELECT privilege to a DATABASE

От
Albe Laurenz
Дата:
Abhijit Gharami wrote:
> How can we provide only SELECT privilege on all the table in a DATABASE to a user. I checked the
> documents and found that it is possible in schema level of a database.

No, you have to do it schema by schema.

Yours,
Laurenz Albe