Enable update of RDB$DESCRIPTION as a special case of metadata.
---------------------------------------------------------------
Key: CORE-5331
URL: http://tracker.firebirdsql.org/browse/CORE-5331
Project: Firebird Core
Issue Type: Bug
Affects Versions: 3.0.0
Environment: Windows 64bit; probably all other platforms work the same
for this issue.
Reporter: Ann Lynnworth
This syntax for setting the description of a field works in Firebird 2.5 but
not in 3.0 (note: this is using the SYSDBA account) :
UPDATE RDB$RELATION_FIELDS SET RDB$DESCRIPTION = 'autoincrement' WHERE
(RDB$RELATION_NAME = 'INVOICEDET') AND (RDB$FIELD_NAME = 'INVOICEDETNO');
The exception is
ISC ERROR CODE:335545030
ISC ERROR MESSAGE:
UPDATE operation is not allowed for system table RDB$RELATIONS
While it seems reasonable to block general edits to the RELATIONS table,
blocking access to the DESCRIPTION metadata seems counter productive.
This might be a documentation issue. There is a section in the docs, "User
Privileges for Metadata Changes," which implies that there might be a way to
enable changes to Metadata. It is unclear why any GRANT statement would be
needed when operating as SYSDBA, and it is unclear which object(s) need to have
extra permissions in order to set the Description property of a field. If
there is a way to use a GRANT statement to override the readonly nature of the
system tables, that would be well worth documenting as one of the example
statements in that section.
--
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
------------------------------------------------------------------------------
What NetFlow Analyzer can do for you? Monitors network bandwidth and traffic
patterns at an interface-level. Reveals which users, apps, and protocols are
consuming the most bandwidth. Provides multi-vendor support for NetFlow,
J-Flow, sFlow and other flows. Make informed decisions using capacity
planning reports. http://sdm.link/zohodev2dev
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
