04.04.2013 23:03, Roman Simakov wrote: > 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.
I failed to find what the SQL spec says regarding select privileges vs asterisks inside the query specification. So, being treated this way, I agree it could be a solution. Dmitry ------------------------------------------------------------------------------ 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