View Revisions: Issue #8614

Summary 0008614: Fix showing related records for the user that is not an owner of linked tables
Revision 2019-09-04 14:55 by Sergey Pashkov
Description ??? ??????????? ???? ???? superuser, ??? ???????????? ??, ????????? ???????? ??????????? ????????? ?????? ? Valentina Studio.

??????? ?????? ???? ??????? ?????: http://www.valentina-db.com/bt/view.php?id=7053

"ERROR: zero-length delimited identifier at or near """"
LINE 1: ...N "databasename"."tablename" alias 1 on ALIAS1."" = alias..."

?????? ? ?? ??? ????????????? ??????:

SELECT COUNT(*) FROM ... ... FROM "public"."account" alias2 JOIN "public"."company" alias1 ON alias1."" = alias2."company_id" ) AS subQuery ORDER BY "id" ASC ) as countQuery

???? ??? ????????????? ??????? Design Link, ?? ? ??????? ???? ????? ??????, ??????????? ????. ??? superuser ?????? ???. ??????, ??? ???????? ? ???????, ?? ? ?????? ?? ???????, ?.?. ????????? ??? ???. ????????, ??? ???? ALL privileges on ALL TABLE IN SCHEMA schemaname to user ?????? ???? ??????????, ?? ??? ?? ???.
Revision 2019-08-28 10:17 by Alexander
Description ??? ??????????? ???? ???? superuser, ??? ???????????? ??, ????????? ???????? ??????????? ????????? ?????? ? Valentina Studio.

??????? ?????? ???? ??????? ?????: http://www.valentina-db.com/bt/view.php?id=7053

"ERROR: zero-length delimited identifier at or near """"
LINE 1: ...N "databasename"."tablename" alias 1 on ALIAS1."" = alias..."

?????? ? ?? ??? ????????????? ??????:

SELECT COUNT(*) FROM ... ... FROM "public"."account" alias2 JOIN "public"."company" alias1 ON alias1."" = alias2."company_id" ) AS subQuery ORDER BY "id" ASC ) as countQuery

???? ??? ????????????? ??????? Design Link, ?? ? ??????? ???? ????? ??????, ??????????? ????. ??? superuser ?????? ???. ??????, ??? ???????? ? ???????, ?? ? ?????? ?? ???????, ?.?. ????????? ??? ???. ????????, ??? ???? ALL privileges on ALL TABLE IN SCHEMA schemaname to user ?????? ???? ??????????, ?? ??? ?? ???.