Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

non admin user cannot create temporary tables #2916

Closed
monetdb-team opened this issue Nov 30, 2020 · 0 comments
Closed

non admin user cannot create temporary tables #2916

monetdb-team opened this issue Nov 30, 2020 · 0 comments
Labels
bug Something isn't working major SQL

Comments

@monetdb-team
Copy link

Date: 2011-10-29 14:58:42 +0200
From: ultan <>
To: SQL devs <>
Version: 11.9.1 (Apr2012) [obsolete]
CC: @njnes

Last updated: 2012-05-25 12:58:45 +0200

Comment 16494

Date: 2011-10-29 14:58:42 +0200
From: ultan <>

User-Agent: Mozilla/5.0 (X11; Linux i686; rv:7.0.1) Gecko/20100101 Firefox/7.0.1
Build Identifier:

Creating a user under monetdb and then connecting as that user, it would be expected that that user could create temporary tables in the tmp schema.

Reproducible: Always

Steps to Reproduce:

connect with mclient to a database as admin user monetdb
create a user
disconnect
connect with mclient as new user
attempt to create a temporary table

Actual Results:

receive error that user has insufficient privileges.

For example:

ultan@boxer:/$ mclient -d TEST2H
user:monetdb
password:
Welcome to mclient, the MonetDB/SQL interactive terminal (Aug2011-SP1)
Database: MonetDB v11.5.3, 'TEST2H'
Type \q to quit, ? for a list of available commands
auto commit mode: on
sql>create user TestUser with password 'password' name 'uoc' schema "sys";
operation successful (117.441ms)
sql>\q
ultan@boxer:
/$ mclient -u TestUser -d TEST2H
password:
Welcome to mclient, the MonetDB/SQL interactive terminal (Aug2011-SP1)
Database: MonetDB v11.5.3, 'TEST2H'
Type \q to quit, ? for a list of available commands
auto commit mode: on
sql>create global temporary table t (col1 int);
CREATE TABLE: insufficient privileges for user 'ultan' in schema 'tmp'
sql>create local temporary table t (col1 int);
CREATE TABLE: insufficient privileges for user 'ultan' in schema 'tmp'
sql>create temporary table t (col1 int);
CREATE TABLE: insufficient privileges for user 'ultan' in schema 'tmp'
sql>

Expected Results:

expect temporary table creation to be allowed and successful

Comment 16581

Date: 2011-11-29 10:45:31 +0100
From: @grobian

With the Dec2011 branch:

% $INSTALL_DIR/bin/mclient -u testuser test2h
password:
Welcome to mclient, the MonetDB/SQL interactive terminal (Dec2011-a3d851cb1775)
Database: MonetDB v11.7.0 (Dec2011-a3d851cb1775), 'mapi:monetdb://vomac.cwi.nl:54321/test2h'
Type \q to quit, ? for a list of available commands
auto commit mode: on
sql>create global temporary table t (col1 int);
CREATE TABLE: insufficient privileges for user 'testuser' in schema 'tmp'
sql>create local temporary table t (col1 int);
operation successful (17.816ms)
sql>create temporary table t (col1 int);
CREATE TABLE: name 't' already in use
sql>drop table t;
operation successful (4.918ms)
sql>create temporary table t (col1 int);
operation successful (3.024ms)
sql>

That is, we now allow creating temporary tables and local temporary tables, but not global temporary tables. Is this enough for you?

Comment 17237

Date: 2012-05-07 20:42:02 +0200
From: @njnes

global temporaries change the global schema, as such by default new users do not have such rights.

@monetdb-team monetdb-team added bug Something isn't working major SQL labels Nov 30, 2020
@sjoerdmullender sjoerdmullender added this to the Ancient Release milestone Nov 9, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working major SQL
Projects
None yet
Development

No branches or pull requests

2 participants