On Wed, May 27, 2015 at 10:33:45AM -0700, Raffael Marty wrote:
create user “ram" with password ‘xxx' name ‘ram' schema "sys"; create schema “ram" authorization “ram”; alter user ram set schema “ram”; create table flows (…); grant all on flows to ram;
the default function resolving is done within the users schema. Which is 'ram' for you 'ram' user. The left_shit(inet,int) function is in the sys schema, ie select * from test where sys.left_shift(a, inet '10.0.0.0/8'); should work (for now).
Could you file bug this on the bugtracker?
Niels
Thanks
Raffael
—
Visual Analytics Workshop at #BlackHat US in August: http://bit.ly/1FN1W5e Raffael Marty ceo @ pixlcloud http://pixlcloud.com @raffaelmarty http://raffy.ch
On May 27, 2015, at 10:25 AM, Niels Nes Niels.Nes@cwi.nl wrote:
On Wed, May 27, 2015 at 10:01:31AM -0700, Raffael Marty wrote:
I have a table called ip_range with an inet field (ip). I do the following query:
select * from ip_range where ip << inet '10.0.0.0/8’ SELECT: no such binary operator 'left_shift(inet,inet)'
Which results in an error. This is by using a non system user. If I create the same table as moentdb user and do the same query, it works as intended. Am I missing something with regards to permissions?
Running 11.19.11-20150 on Ubuntu.
Thanks
Raffael
To reproduce:
create table test (a inet); insert into test (a) values ('10.0.0.1’); select * from test where a << inet '10.0.0.0/8’;
how did you create the user?
Niels
—
Visual Analytics Workshop at #BlackHat US in August: http://bit.ly/1FN1W5e Raffael Marty ceo @ pixlcloud http://pixlcloud.com @raffaelmarty http://raffy.ch _______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
-- Niels Nes, Manager ITF, Centrum Wiskunde & Informatica (CWI) Science Park 123, 1098 XG Amsterdam, The Netherlands room L3.14, phone ++31 20 592-4098 sip:4098@sip.cwi.nl url: https://www.cwi.nl/people/niels e-mail: Niels.Nes@cwi.nl _______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list