On 05/29/12 16:58, Dalton Calford wrote: > On 29 May 2012 03:51, Alex Peshkoff <[email protected]> wrote: >> There is syntax problem with providing comments on privileges - >> privileges do not have names. > > Is it not possible to extend the syntax of the comment on DDL? for example > > COMMENT ON [SELECT|UPDATE|INSERT|DELETE|ALL] GRANT FOR [USER|ROLE] UPON > [TABLE|VIEW|PROCEDURE] IS .......... >
That's possible, but please add GRANTED BY. It's also a part of unique key for a privilege. > The above is very clumsy but a better way would be > > GRANT [RIGHT] FOR [OBJECT] TO [USER|ROLE] AS GRANT_NAME > Also possible, but violates SQL standard. > Then COMMENT ON GRANT GRANT_NAME is ....... > > Also, if we are going to be maintaining the users in the database itself, > perhaps a comment upon the user..... > Very possible, and does not depend upon a database, where the users are maintained. >> 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. >> >> > Sounds reasonable - do you have any idea when namespaces/schema are going > to be looked at? The use of schema and the expansion of the width of the > sql object names would benefit Firebird greatly - especially for those who > use multibyte character sets for their databases. > I suppose in next after FB3 version - definitely. (Can't promise about FB3 - or we will never see it released.) ------------------------------------------------------------------------------ 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
