Thread: Table inheritance over schema boundaries possible
Hi all I am wondering if table inheritance is possible over the boundaries of schemata and different owners. I have database act with schemata il and scd. When I issue as IL create table IL.INHERITANCE_TEST() inherits (SCD.TEMPL_BK); I get [Code: 0, SQL State: 42501] ERROR: permission denied for schema scd Even though I granted all privileges to IL. What am I missing or is it just not possible what I want to do? Kind regards Thiemo -- S/MIME Public Key: https://oc.gelassene-pferde.biz/index.php/s/eJuAUFONag6ofnH Signal (Safer than WhatsApp): +49 1578 7723737 Handys: +41 78 947 36 21 | +49 1578 772 37 37 Tox-Id: B7282A9E31D944DDAD1ECC5B33C36AAE80B32D119AB7391D602C937A65E8CA0625C495C5322B
Attachment
On 23/5/19 8:46 π.μ., Thiemo Kellner wrote: > Hi all > > I am wondering if table inheritance is possible over the boundaries of schemata and different owners. > > I have database act with schemata il and scd. When I issue as IL > > create table IL.INHERITANCE_TEST() inherits (SCD.TEMPL_BK); > > I get > > [Code: 0, SQL State: 42501] ERROR: permission denied for schema scd > > Even though I granted all privileges to IL. > > What am I missing or is it just not possible what I want to do? as of 10 (same with 11) you (IL) must be the owner of relation SCD.TEMPL_BK . Create your tables with a user who has correct privileges on both tables/schemas. > > Kind regards > > Thiemo > -- Achilleas Mantzios IT DEV Lead IT DEPT Dynacom Tankers Mgmt
Quoting Achilleas Mantzios <achill@matrix.gatewaynet.com>: > as of 10 (same with 11) you (IL) must be the owner of relation SCD.TEMPL_BK . > Create your tables with a user who has correct privileges on both > tables/schemas. Not what I hope for but was afraid of. thank you for the answer. > -- > Achilleas Mantzios > IT DEV Lead > IT DEPT > Dynacom Tankers Mgmt -- S/MIME Public Key: https://oc.gelassene-pferde.biz/index.php/s/eJuAUFONag6ofnH Signal (Safer than WhatsApp): +49 1578 7723737 Handys: +41 78 947 36 21 | +49 1578 772 37 37 Tox-Id: B7282A9E31D944DDAD1ECC5B33C36AAE80B32D119AB7391D602C937A65E8CA0625C495C5322B