BharatAnalyst commented on issue #900: Visibility Issues in Accumulo when scaning a table. Getting following error :- error bad authorizations for user on table T1 (id:1y) - the user visuser does not have the specified authorizations assigned URL: https://github.com/apache/accumulo/issues/900#issuecomment-454591371 This is on single node cluster only. And following is the output for a new user viz2 for which i set the authorization through the java call and the error and then i setauths on command line and then the successful scan :- root@accumulo> user viz2 Enter password for user viz2: **** viz2@accumulo> getauths b0,b1,b2,b3,b4,b5,b6,b7 viz2@accumulo> scan -t accumulo.industry_customer_visibility -s b0 2019-01-15 06:25:21,143 [shell.Shell] ERROR: java.lang.RuntimeException: org.apache.accumulo.core.client.AccumuloSecurityException: Error BAD_AUTHORIZATIONS for user viz2 on table accumulo.industry_customer_visibility(ID:1y) - The user does not have the specified authorizations assigned viz2@accumulo> user root Enter password for user root: ***** root@accumulo> setauths -u viz2 -s b0,b1,b2,b3,b4,b5,b6,b7 root@accumulo> user viz2 Enter password for user viz2: **** viz2@accumulo> scan -t accumulo.industry_customer_visibility -s b0 test:accumulo.industry_customer_visibility:1e0e6317-185d-4595-a626-6ffbac0b374a ___ROW___:___ROW___ [] test:accumulo.industry_customer_visibility:1e0e6317-185d-4595-a626-6ffbac0b374a test:accumulo.industry_customer_visibility:1e0e6317-185d-4595-a626-6ffbac0b374a account_established_date:account_established_date [b0|b1|b2|b3|b4|b5|b6|b7|b8|b9] Mon Oct 04 16:00:00 PDT 2004 test:accumulo.industry_customer_visibility:1e0e6317-185d-4595-a626-6ffbac0b374a account_established_date_2:account_established_date_2 [b0|b1|b2|b3|b4|b5|b6|b7|b8|b9] Mon Oct 04 16:00:00 PDT 2004 test:accumulo.industry_customer_visibility:1e0e6317-185d-4595-a626-6ffbac0b374a industry_account_type_1:industry_account_type_1 [b0|b1|b2|b3|b4|b5|b6|b7|b8|b9] 0 test:accumulo.industry_customer_visibility:1e0e6317-185d-4595-a626-6ffbac0b374a industry_account_type_2:industry_account_type_2 [b0|b1|b2|b3|b4|b5|b6|b7|b8|b9] 1 test:accumulo.industry_customer_visibility:1e0e6317-185d-4595-a626-6ffbac0b374a industry_id:industry_id [b0|b1|b2|b3|b4|b5|b6|b7|b8|b9] 0 test:accumulo.industry_customer_visibility:1e0e6317-185d-4595-a626-6ffbac0b374a check_returned_count:check_returned_count [b0|b1|b2|b3|b4|b5|b6|b7|b8|b9] \x08\x80\x00\x00\x00\x00\x00\x00\x02 test:accumulo.industry_customer_visibility:1e0e6317-185d-4595-a626-6ffbac0b374a good_standing_rank:good_standing_rank [b0|b1|b2|b3|b4|b5|b6|b7|b8|b9] \x08\x80\x00\x00\x00\x00\x00\x00\x01 test:accumulo.industry_customer_visibility:1e0e6317-185d-4595-a626-6ffbac0b374a good_standing_rank_2:good_standing_rank_2 [b0|b1|b2|b3|b4|b5|b6|b7|b8|b9] \x08\x80\x00\x00\x00\x00\x00\x00\x00 test:accumulo.industry_customer_visibility:1e0e6317-185d-4595-a626-6ffbac0b374a accumulo_ingest_dataset:accumulo_ingest_dataset [] accumulo.industry_customer_visibility test:accumulo.industry_customer_visibility:1e0e6317-185d-4595-a626-6ffbac0b374a accumulo_owner:accumulo_owner [] test test:accumulo.industry_customer_visibility:1e0e6317-185d-4595-a626-6ffbac0b374a record_date_stamp:record_date_stamp [] Mon Oct 04 16:00:00 PDT 2004 test:accumulo.industry_customer_visibility:1e0e6317-185d-4595-a626-6ffbac0b374a record_id:record_id [] \x08\x80\x00\x00\x00\x00\x02\x98\x13 test:accumulo.industry_customer_visibility:49af9616-744e-4a1d-a3b2-529472d01792 ___ROW___:___ROW___ [] test:accumulo.industry_customer_visibility:49af9616-744e-4a1d-a3b2-529472d01792 test:accumulo.industry_customer_visibility:49af9616-744e-4a1d-a3b2-529472d01792 account_established_date:account_established_date [b0|b1|b2|b3|b4|b5|b6|b7|b8|b9] Mon Oct 04 16:00:00 PDT 2004 test:accumulo.industry_customer_visibility:49af9616-744e-4a1d-a3b2-529472d01792 account_established_date_2:account_established_date_2 [b0|b1|b2|b3|b4|b5|b6|b7|b8|b9] Mon Oct 04 16:00:00 PDT 2004 test:accumulo.industry_customer_visibility:49af9616-744e-4a1d-a3b2-529472d01792 industry_account_type_1:industry_account_type_1 [b0|b1|b2|b3|b4|b5|b6|b7|b8|b9] 0 test:accumulo.industry_customer_visibility:49af9616-744e-4a1d-a3b2-529472d01792 industry_account_type_2:industry_account_type_2 [b0|b1|b2|b3|b4|b5|b6|b7|b8|b9] 1 test:accumulo.industry_customer_visibility:49af9616-744e-4a1d-a3b2-529472d01792 industry_id:industry_id [b0|b1|b2|b3|b4|b5|b6|b7|b8|b9] 0 test:accumulo.industry_customer_visibility:49af9616-744e-4a1d-a3b2-529472d01792 check_returned_count:check_returned_count [b0|b1|b2|b3|b4|b5|b6|b7|b8|b9] \x08\x80\x00\x00\x00\x00\x00\x00\x02 test:accumulo.industry_customer_visibility:49af9616-744e-4a1d-a3b2-529472d01792 good_standing_rank:good_standing_rank [b0|b1|b2|b3|b4|b5|b6|b7|b8|b9] \x08\x80\x00\x00\x00\x00\x00\x00\x01 test:accumulo.industry_customer_visibility:49af9616-744e-4a1d-a3b2-529472d01792 good_standing_rank_2:good_standing_rank_2 [b0|b1|b2|b3|b4|b5|b6|b7|b8|b9] \x08\x80\x00\x00\x00\x00\x00\x00\x00 test:accumulo.industry_customer_visibility:49af9616-744e-4a1d-a3b2-529472d01792 accumulo_ingest_dataset:accumulo_ingest_dataset [] accumulo.industry_customer_visibility test:accumulo.industry_customer_visibility:49af9616-744e-4a1d-a3b2-529472d01792 accumulo_owner:accumulo_owner [] test test:accumulo.industry_customer_visibility:49af9616-744e-4a1d-a3b2-529472d01792 record_date_stamp:record_date_stamp [] Mon Oct 04 16:00:00 PDT 2004 test:accumulo.industry_customer_visibility:49af9616-744e-4a1d-a3b2-529472d01792 record_id:record_id [] \x08\x80\x00\x00\x00\x00\x02\x98h ---------------------------------------------------------- hit any key to continue or 'q' to quit --------------------------------------- ---------------------------------------------------------------- This is an automated message from the Apache Git Service. To respond to the message, please log on GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: users@infra.apache.org With regards, Apache Git Services