[FB-Tracker] Created: (CORE-5523) The revoke statement fails

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view

[FB-Tracker] Created: (CORE-5523) The revoke statement fails

JIRA tracker@firebirdsql.org
The revoke statement fails

                 Key: CORE-5523
                 URL: http://tracker.firebirdsql.org/browse/CORE-5523
             Project: Firebird Core
          Issue Type: Bug
    Affects Versions: 3.0.2
         Environment: Windows 10, firebird 3.0 and flamerobin
            Reporter: Vicente Tejero Trueba

I'm a user SYSDBA.
I have a table Concursantes and a role Alumnos.
I grant the select privileges on Concursantes to Alumnos.

When I execute the statement

Fails with message
 SQL Message : -607
This operation is not defined for system tables.

Engine Code    : 335544351
Engine Message :
unsuccessful metadata update
REVOKE failed
SYSDBA is not grantor of Select on CONCURSANTES to ALUMNOS.

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


Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel