| Subject | FB3 - no permission for SELECT access to TABLE PLG$SRP |
|---|---|
| Author | liviuslivius |
| Post date | 2018-05-18T09:33:04Z |
Hi,
can you help me fix below problem?
when connected user try to select on SEC$ for data
he got an error:
----------------------------
find/display record error
no permission for SELECT access to TABLE PLG$SRP.
-----------------------------
e.g.
SELECT
U.SEC$USER_NAME
, (SELECT UA.SEC$VALUE FROM SEC$USER_ATTRIBUTES UA WHERE UA.SEC$USER_NAME=U.SEC$USER_NAME AND UA.SEC$KEY='DYR_ID') AS GID
, (SELECT UA.SEC$VALUE FROM SEC$USER_ATTRIBUTES UA WHERE UA.SEC$USER_NAME=U.SEC$USER_NAME AND UA.SEC$KEY='PRAC_ID') AS UID
FROM
SEC$USERS U
WHERE
U.SEC$USER_NAME='KBIENIASZEWSKI'
----------------------------------
I am logged as KBIENIASZEWSKI and i look for self data.
How to fix this.
Server Version
WI-V3.0.4.32972 Firebird 3.0
Database ODS 12.2
regards,
Karol Bieniaszewski