Jul2015: access denied to sys.tables from custom user/schema - users-list - monetdb.org

newer
Announcement: New Jul2015 Feature...

Jul2015: access denied to sys.tables from custom user/schema

older
I love Jul2015!

Roberto Cornacchia

31 Aug 2015 31 Aug '15

3:15 p.m.

Hi there, Is it a Jul2015 feature that access to sys.tables is denied to custom a user/schema? However, sys._tables is accessible. That sounds strange. Roberto

Attachments:

attachment.html (text/html — 267 bytes)

Reply

Sign in to reply online Use email software

Show replies by date

Niels Nes

31 Aug 31 Aug

3:17 p.m.

On Mon, Aug 31, 2015 at 05:15:21PM +0200, Roberto Cornacchia wrote:

Hi there,

Is it a Jul2015 feature that access to sys.tables is denied to custom a user/schema?

However, sys._tables is accessible. That sounds strange. indeed, seems some bug.

Niels

Roberto

_______________________________________________ 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

Reply

Sign in to reply online Use email software

Roberto Cornacchia

1 Sep 1 Sep

2:37 p.m.

This seem to happen only on one specific database (which is likely to have been created with Oct2014). I cannot reproduce it on other databases. So let's just hope it was due to some db corruption. Should it happen again I'll follow up. Roberto On 31 August 2015 at 17:17, Niels Nes wrote:

On Mon, Aug 31, 2015 at 05:15:21PM +0200, Roberto Cornacchia wrote:

...
Hi there,

Is it a Jul2015 feature that access to sys.tables is denied to custom a user/schema?

However, sys._tables is accessible. That sounds strange. indeed, seems some bug.

Niels

...
Roberto

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

Reply

Sign in to reply online Use email software

Dennis Pallett

2 Sep 2 Sep

10:23 a.m.

We had the exact same problem and solved it by running the following query as an administrator: GRANT ALL ON sys.tables TO custom_user. On Tue, Sep 1, 2015 at 4:37 PM, Roberto Cornacchia < roberto.cornacchia@gmail.com> wrote:

This seem to happen only on one specific database (which is likely to have been created with Oct2014). I cannot reproduce it on other databases. So let's just hope it was due to some db corruption.

Should it happen again I'll follow up.

Roberto

On 31 August 2015 at 17:17, Niels Nes wrote:

...
On Mon, Aug 31, 2015 at 05:15:21PM +0200, Roberto Cornacchia wrote:

...
Hi there,

Is it a Jul2015 feature that access to sys.tables is denied to custom a user/schema?

However, sys._tables is accessible. That sounds strange. indeed, seems some bug.

Niels

...
Roberto

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

Reply

Sign in to reply online Use email software

Roberto Cornacchia

10:27 a.m.

If this is true then there must indeed be a bug somewhere, because it's not consistent. Granting the privilege should be either required or not On 2 September 2015 at 12:23, Dennis Pallett wrote:

We had the exact same problem and solved it by running the following query as an administrator:

GRANT ALL ON sys.tables TO custom_user.

On Tue, Sep 1, 2015 at 4:37 PM, Roberto Cornacchia < roberto.cornacchia@gmail.com> wrote:

...
This seem to happen only on one specific database (which is likely to have been created with Oct2014). I cannot reproduce it on other databases. So let's just hope it was due to some db corruption.

Should it happen again I'll follow up.

Roberto

On 31 August 2015 at 17:17, Niels Nes wrote:

...
On Mon, Aug 31, 2015 at 05:15:21PM +0200, Roberto Cornacchia wrote:

...
Hi there,

Is it a Jul2015 feature that access to sys.tables is denied to custom a user/schema?

However, sys._tables is accessible. That sounds strange. indeed, seems some bug.

Niels

...
Roberto

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

_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list

Reply

Sign in to reply online Use email software

3405

Age (days ago)

3407

Last active (days ago)

Download

4 comments

3 participants

tags

participants (3)

Dennis Pallett
Niels Nes
Roberto Cornacchia