Re: Permission Issues

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; 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 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