Обсуждение: DROPPING INDEX error
I'm trying to drop an index from called t_sub_ind_1 from table t_submissions using the role update_all. The role has been granted full access privileges on the table from which the index is to be dropped. However when trying to drop the index, sqlca.sqlerrm.sqlerrmc is reporting the following error:
must be owner of relation t_sub_ind_1 on line 1188
I then dropped the index manually from the database, logged in as myself and I have full administrator priviliges. Ran the code again and this time it fell over when trying to create the index, saying:
must be owner of relation t_submissions on line 1214
does not having full access privileges as role update_all, also entitle me to drop and create indexes?
Also how can I find out the owners of a table/index?
Thanks
Atif
> Also how can I find out the owners of a table/index? SELECT * FROM PG_TABLES SELECT * FROM PG_INDEXES Regards, Jayadevan DISCLAIMER: "The information in this e-mail and any attachment is intended only for the person to whom it is addressed and may contain confidential and/or privileged material. If you have received this e-mail in error, kindly contact the sender and destroy all copies of the original communication. IBS makes no warranty, express or implied, nor guarantees the accuracy, adequacy or completeness of the information contained in this email or any attachment and is not liable for any errors, defects, omissions, viruses or for resultant loss or damage, if any, direct or indirect."
Atif Jung <atifjung@gmail.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