Message "Statement failed, SQLSTATE = 00000 + unknown ISC error 0" appears when
issuing REVOKE ALL ON ALL FROM <existing_user>
------------------------------------------------------------------------------------------------------------------------------
Key: CORE-4719
URL: http://tracker.firebirdsql.org/browse/CORE-4719
Project: Firebird Core
Issue Type: Bug
Components: API / Client Library
Reporter: Pavel Zotov
C:\MIX\firebird\QA\fbt-repo\tmp>C:\MIX\firebird\fb30sc\isql.exe
localhost/3330:C:\MIX\firebird\QA\fbt-repo\tmp\e30.fdb
Database: localhost/3330:C:\MIX\firebird\QA\fbt-repo\tmp\e30.fdb
SQL> show version;
ISQL Version: WI-T3.0.0.31733 Firebird 3.0 Beta 2
Server version:
Firebird/Windows/Intel/i386 (access method), version "WI-T3.0.0.31733 Firebird
3.0 Beta 2"
Firebird/Windows/Intel/i386 (remote server), version "WI-T3.0.0.31733 Firebird
3.0 Beta 2/tcp (csprog)/P13"
Firebird/Windows/Intel/i386 (remote interface), version "WI-T3.0.0.31733
Firebird 3.0 Beta 2/tcp (csprog)/P13"
on disk structure version 12.0
SQL> create user tmp1 password 'tmp1';
SQL> commit;
SQL> revoke all on all from tmp1;
Statement failed, SQLSTATE = 00000
unknown ISC error 0
Warning: ALL on ALL is not granted to TMP1.
PS.
Env. variable PATH does contain the same folder ( 'C:\MIX\firebird\fb30sc' )
as I've specified when launched ISQL command.
NO variable 'FIREBIRD' is defined on that machine.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
Dive into the World of Parallel Programming The Go Parallel Website, sponsored
by Intel and developed in partnership with Slashdot Media, is your hub for all
things parallel software development, from weekly thought leadership blogs to
news, videos, case studies, tutorials and more. Take a look and join the
conversation now. http://goparallel.sourceforge.net/
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
