Privileges to sequences?

[Carol Walter <walterc@xxxxxxxxxxx>]

Hello,

I've had trouble several times when granting permissions on tables  
when I had not also granted permission to the sequence.  The  
sequences may only have select, insert, and usage privileges.  I can  
guess that when I grant select privileges on a table, I need to grant  
select privileges to the sequence and I can guess that if I grant  
insert privileges to a table I need to grant the insert privilege to  
the sequence.  I don't know when to usage and I don't know what  
privileges, if any, I need to grant to the sequence if I'm going to  
give delete, update, or references privileges on the tables.

Thanks,
Carol