You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
example table with one record - still not protected
Reproducible: Always
Steps to Reproduce:
CREATE TABLE my_table AS SELECT 1 AS my_column WITH DATA;
ALTER TABLE my_table SET READ ONLY;
SELECT COUNT(*) FROM my_table;
DROP TABLE my_table;
Actual Results:
Welcome to mclient, the MonetDB/SQL interactive terminal (Jul2015-91007a50e91b)
Database: MonetDB v11.21.8 (Jul2015-91007a50e91b), 'demo'
Type \q to quit, ? for a list of available commands
auto commit mode: on
sql>CREATE TABLE my_table AS SELECT 1 AS my_column WITH DATA;
operation successful (11.739ms)
sql>ALTER TABLE my_table SET READ ONLY;
operation successful (5.956ms)
sql>SELECT COUNT(*) FROM my_table;
+------+
| L1 |
+======+
| 1 |
+------+
1 tuple (0.703ms)
sql>DROP TABLE my_table;
operation successful (5.322ms)
sql>
protecting agains ddl statements is done using grant and revoke privileges. The
table level read only flags only protect the row level content, ie disallowes
update/insert and delete statements. This allows for less delta statements, ie
more efficient bat access.
Comment 21688
Date: 2015-12-23 13:17:52 +0100
From: Anthony Damico <>
ahh, i misunderstood that, sorry.
you wrote "resolved nextrelease" - but i do not see a changeset. does that mean you have also prevented DROP TABLE from occurring on read-only tables? or are read only tables allowed to be dropped?
thanks niels!!
The text was updated successfully, but these errors were encountered:
Date: 2015-12-22 22:55:33 +0100
From: Anthony Damico <>
To: SQL devs <>
Version: 11.21.5 (Jul2015)
CC: ajdamico, @njnes
Last updated: 2016-01-15 11:37:56 +0100
Comment 21684
Date: 2015-12-22 22:55:33 +0100
From: Anthony Damico <>
User-Agent: Mozilla/5.0 (Windows NT 6.3; WOW64; rv:43.0) Gecko/20100101 Firefox/43.0
Build Identifier:
example table with one record - still not protected
Reproducible: Always
Steps to Reproduce:
CREATE TABLE my_table AS SELECT 1 AS my_column WITH DATA;
ALTER TABLE my_table SET READ ONLY;
SELECT COUNT(*) FROM my_table;
DROP TABLE my_table;
Actual Results:
Welcome to mclient, the MonetDB/SQL interactive terminal (Jul2015-91007a50e91b)
Database: MonetDB v11.21.8 (Jul2015-91007a50e91b), 'demo'
Type \q to quit, ? for a list of available commands
auto commit mode: on
sql>CREATE TABLE my_table AS SELECT 1 AS my_column WITH DATA;
operation successful (11.739ms)
sql>ALTER TABLE my_table SET READ ONLY;
operation successful (5.956ms)
sql>SELECT COUNT(*) FROM my_table;
+------+
| L1 |
+======+
| 1 |
+------+
1 tuple (0.703ms)
sql>DROP TABLE my_table;
operation successful (5.322ms)
sql>
Expected Results:
table should not be dropped
Comment 21687
Date: 2015-12-23 10:20:42 +0100
From: @njnes
protecting agains ddl statements is done using grant and revoke privileges. The
table level read only flags only protect the row level content, ie disallowes
update/insert and delete statements. This allows for less delta statements, ie
more efficient bat access.
Comment 21688
Date: 2015-12-23 13:17:52 +0100
From: Anthony Damico <>
ahh, i misunderstood that, sorry.
you wrote "resolved nextrelease" - but i do not see a changeset. does that mean you have also prevented DROP TABLE from occurring on read-only tables? or are read only tables allowed to be dropped?
thanks niels!!
The text was updated successfully, but these errors were encountered: