Jul2015: access denied to sys.tables from custom user/schema
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
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
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 Niels.Nes@cwi.nl 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
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 Niels.Nes@cwi.nl 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
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 dennis@pallett.nl 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 Niels.Nes@cwi.nl 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
participants (3)
-
Dennis Pallett -
Niels Nes -
Roberto Cornacchia