1

Topic: Type usage serial c GRANT INSERT

All hello. There was a problem, decided xxx to use in the table PK a field with serial, all works remarkably with the user posgres but as soon as I create the new user and I give to it GRANT INSERT ON TABLE xxx TO user200, the field where serial ceases to work. Prompt how to solve please a situation, without additional scripts and , allowing user200 to write down only the data without reading and change?

2

Re: Type usage serial c GRANT INSERT

malika9;
serial - an essence syntactic sugar over sequence. Here on this the most created sequence too it is necessary for you to grant the rights. GRANT USAGE ON SEQUENCE it is necessary for a call nextval

3

Re: Type usage serial c GRANT INSERT

Melkij;
Thanks you big)