I got this working by adding a new schema and a database role. The user can add, delete tables in the new schema and the has privileges in the...

This is not working.

I created a test database with a "teams" table and a "players" table. These are the 2 tables that I don't want users to be able...

I want the new role to be able to read the old tables, but not able to create, edit or delete data.

I will give that a try.

Thanks Tom!