Skip to content

Sharing a table read-write doesn't give access to sequences #321

@javitonino

Description

@javitonino

STR

  • Share a table RW with another user in the organization
  • As the second user, execute an INSERT without specifying PK: INSERT INTO owner.untitled_table (name) VALUES ('a')

Error: permission denied for sequence untitled_table_cartodb_id_seq0

We should give sequence access as well in

FUNCTION cartodb.CDB_Organization_Add_Table_Read_Write_Permission(from_schema text, table_name text, to_role_name text)

Metadata

Metadata

Assignees

Labels

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions