2013/4/4 Dmitry Yemanov <firebi...@yandex.ru>:
> IIRC, the SQL spec declares select permissions for columns. And they're
> surely intended to throw errors, not to hide something.

In RedDatabase we do not expand * in query "select * from T" into all
fields of T but only in fields which user can access.
IMO produce an error is incorrect in this case. User just want to see
all available fields.
Also IMO it can be a solution of original problem. Just revoke select
permission of service "hidden" fields. Only granted replication
procedures will have an access to them.


--
Roman Simakov

------------------------------------------------------------------------------
Minimize network downtime and maximize team effectiveness.
Reduce network management and security costs.Learn how to hire 
the most talented Cisco Certified professionals. Visit the 
Employer Resources Portal
http://www.cisco.com/web/learning/employer_resources/index.html
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Reply via email to