On 05/29/12 00:43, Dalton Calford wrote:
> COMMENT ON *<object>* IS {'*sometext*' | NULL}
> *<object>* ::= DATABASE
> | *<basic-type>* *objectname*
> | COLUMN *relationname*.*fieldname*
> | PARAMETER *procname*.*paramname*
> *<basic-type>* ::= CHARACTER SET | COLLATION | DOMAIN | EXCEPTION
> | EXTERNAL FUNCTION | FILTER | GENERATOR | INDEX
> | PROCEDURE | ROLE | SEQUENCE | TABLE | TRIGGER | VIEW
> | CONSTRAINT |PRIVILEGE
>
>
> Now the last one is for comments upon security privileges as in why a
> particular user or role would need that specific security right.
>
There is syntax problem with providing comments on privileges -
privileges do not have names.
> >From what I can see, there is no place to hold the descriptions for these
> new comments so a system table change would be needed if this was
> implemented.
>
Adding new field to existing table(s) is not a problem in ODS12 (FB3).
> Also, from a users perspective, I can not find any documentation on how to
> see the comments upon an object except by querying the system tables.
>
Querying them is OK from sql2008 POV. As soon as we have namespaces we
will provide views, making it possible to extract data from system
tables in a standard manner. Adding new non-select commands for it is
not correct way to go.
------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond. Discussions
will include endpoint security, mobile security and the latest in malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
