Atif Jung <atifjung(at)gmail(dot)com> writes:
> does not having full access privileges as role update_all, also entitle me
> to drop and create indexes?
No. DDL changes to a table require being the table's owner, or at least
a member of the owning role.
regards, tom lane