Permission Issues

Raffael Marty

27 May 2015 27 May '15

5:01 p.m.

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’; — Visual Analytics Workshop at #BlackHat US in August: http://bit.ly/1FN1W5e Raffael Marty ceo @ pixlcloud http://pixlcloud.com @raffaelmarty http://raffy.ch

Show replies by date

Niels Nes

27 May 27 May

5:25 p.m.

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

Raffael Marty

5:33 p.m.

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

Niels Nes

5:44 p.m.

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

3503

Age (days ago)

3503

Last active (days ago)

List overview

Download

3 comments

2 participants

participants (2)

Niels Nes
Raffael Marty