Subject Re: [ib-support] MONTH
Author Woody
From: "Claudio Valderrama C." <cvalde@...>
> Are you sure you didn't pick an April fool's Day post?
> Restricting R/W permissions on system tables is right, but why would
> want to break apps that have worked since IB4? Is it necessary to block
> access to rdb$database? Is their IQ so limited? Which is the confidential
> information that rdb$database holds? I assume they are going to put the
> db-wide charset in another table if it can't be queried anymore in
> rdb$database by non-privileged clients.

I know that you frequent the Borland groups, so you must have seen at least
one of these in the past few weeks, no? People such as Bill Todd, etc. have
said these things. They haven't specifically said the access rights might
change but system tables can be changed to suit the engine. As a matter of
fact, I would prefer that IB/FB be given a separate keyword to use instead
of rdb$database that you can use to tell it you aren't really interested in
seeing any records, just using it to execute a command. To use the example
in the original post:

select extract (month from current_date) from rdb$database

would become something like

select extract (month from current_date) from rdb$nothing

The rdb$nothing (or whatever you want to call it) isn't actually a physical
table, just a keyword used to balance the statement.

As for the rest of your post, you're a very funny guy when you want to be...

Woody (TMW)