Обсуждение: about rules

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

about rules

От
prashant sangale
Дата:
How to write a rule to avoid queries like update,insert,delete,select from any database users except superuser.  
 
thanks,
Prashant

Do you Yahoo!?
Yahoo! Search presents - Jib Jab's 'Second Term'

Re: about rules

От
Christopher Kings-Lynne
Дата:
> How to write a rule to avoid queries like update,insert,delete,select 
> from any database users except superuser.  

REVOKE UPDATE,INSERT,DELETE,SELECT ON table FROM PUBLIC, other users;

Chris