Details
-
Bug
-
Resolution: Fixed
-
Critical
-
Columnar 1.0.0
-
Untriaged
-
0
-
Unknown
Description
create dataset orders primary key (oid: int64);
upsert into orders ({"oid": 1, "name": "Janhavi"});
upsert into orders ({"oid": 2, "name": "A"});
User: test_user
What all privileges should be granted to a user to be able to execute the following statement?
create dataset orders_copy primary key (oid: int64) as select value x from orders x
Case1:
- Create collection
- grant create collection in database Default to user test_user
- Select on orders
- grant select on collection orders to user test_user
- Gives error
Case 2:
- Create collection
- grant create collection in database Default to user test_user
- Upsert:
- grant upsert on any collection in database Default to user test_user;
- This works even when test_user doesn't have select privilege on collection orders.
Case 2 should give an error: Insufficient permission.
Attachments
For Gerrit Dashboard: MB-62587 | ||||||
---|---|---|---|---|---|---|
# | Subject | Branch | Project | Status | CR | V |
212636,7 | MB-62587: Testcases for CREATE DATASET AS <QUERY> | master | cbas-core | Status: MERGED | +2 | +1 |