search

FirebirdSQL / firebird

Firebird server, client and tools
https://www.firebirdsql.org/
1.19k stars 205 forks source link

Error.... #8045

Closed Jhironsel closed 2 months ago

Jhironsel commented 2 months ago

SET TERM ^ ; CREATE PROCEDURE ADMIN_CONSULTA_PERMISOS2 RETURNS ( PROFILE_ANY D_BOOLEAN_F ) SQL SECURITY DEFINER AS BEGIN PROFILE_ANY =(select rdb$system_privilege(PROFILE_ANY_ATTACHMENT) from RDB$DATABASE); SUSPEND; END ^ SET TERM ; ^ GRANT EXECUTE ON PROCEDURE ADMIN_CONSULTA_PERMISOS TO SYSDBA WITH GRANT OPTION GRANTED BY SYSDBA;

image

image

Total execution time: 0.024s Committing transaction... Transaction committed (elapsed time: 0.000s). Starting transaction... Preparing statement: CREATE PROCEDURE ADMIN_CONSULTA_PERMISOS2 RETURNS ( PROFILE_ANY D_BOOLEAN_F ) SQL SECURITY DEFINER AS BEGIN PROFILE_ANY =(select rdb$system_privilege(PROFILE_ANY_ATTACHMENT) from RDB$DATABASE); SUSPEND; END

Error: IBPP::SQLException Context: Statement::Prepare( CREATE PROCEDURE ADMIN_CONSULTA_PERMISOS2 RETURNS ( PROFILE_ANY D_BOOLEAN_F ) SQL SECURITY DEFINER AS BEGIN PROFILE_ANY =(select rdb$system_privilege(PROFILE_ANY_ATTACHMENT) from RDB$DATABASE); SUSPEND; END ) Message: isc_dsql_prepare failed

Engine Code : 335545111 Engine Message : unknown ISC error 335545111

hvlad commented 2 months ago
  1. 335545111 is isc_wrong_prvlg and its text is 'System privilege @1 does not exist'
  2. Use correct fbclient.dll to see correct error messages, used one looks too old.
  3. SQL Profiler is a FB5 feature, while you run FB4
Jhironsel commented 2 months ago

Thanks....