Details
-
Bug
-
Status: In Review (View Workflow)
-
Critical
-
Resolution: Unresolved
-
10.5, 10.6, 10.11, 11.4, 11.8
-
None
Description
--source include/not_embedded.inc
|
|
create user 'probsolvdbuser_dev'@'localhost';
|
CREATE DATABASE problsolvdbdev;
|
GRANT INSERT, UPDATE, ALTER ON problsolvdbdev.* TO 'probsolvdbuser_dev'@'localhost';
|
USE problsolvdbdev;
|
CREATE SEQUENCE seq_test START WITH 100 INCREMENT BY 10;
|
CREATE TABLE action_1 (id int);
|
|
connect (conn1,localhost,probsolvdbuser_dev,,problsolvdbdev,);
|
|
alter table action_1 modify `id` int(11) NOT NULL DEFAULT nextval(`seq_test`);
|
|
connection default;
|
drop user 'probsolvdbuser_dev'@'localhost';
|
drop databese problsolvdbdev;
|
Attachments
Issue Links
- is blocked by
-
MDEV-36413 User without any privileges to a sequence can read from it and modify it via column default
-
- In Testing
-
- relates to
-
MDEV-36380 User has unauthorized access to a sequence through a view with security invoker
-
- Open
-
Activity
Transition | Time In Source Status | Execution Times |
---|
|
15d 3h 28m | 1 |
|
1m 33s | 1 |