UNRESTRICT ROWS
Removes the column definition for row-level access control (RLAC)to roles.
When no column is selected, roles that have been granted access on rows (but not the table or keyspace) no longer have access. To restore or change the selected column for RLAC, use the RESTRICT ROWS command.
Syntax
UNRESTRICT ROWS ON [<keyspace_name>.]<table_name> ;
Syntax legend
Syntax conventions | Description |
---|---|
UPPERCASE |
Literal keyword. |
Lowercase |
Not literal. |
|
Variable value. Replace with a user-defined value. |
|
Optional.
Square brackets ( |
|
Group.
Parentheses ( |
|
Or.
A vertical bar ( |
|
Repeatable.
An ellipsis ( |
|
Single quotation ( |
|
Map collection.
Braces ( |
Set, list, map, or tuple.
Angle brackets ( |
|
|
End CQL statement.
A semicolon ( |
|
Separate the command line options from the command arguments with two hyphens ( |
|
Search CQL only: Single quotation marks ( |
|
Search CQL only: Identify the entity and literal value to overwrite the XML element in the schema and solrConfig files. |
Examples
Remove row-level permissions from the currently selected column:
UNRESTRICT ROWS ON cycling.cyclist_expenses;
end::dse68,dse69[]