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
 
 
 
 

Reply via email to