kingbase

1. sql语句

grant all on public.c_account to eia

SELECT table_schema || '.' || table_name
FROM information_schema.TABLES WHERE table_schema ='public'

select 'grant all on ' || table_schema || '.' || table_name || ' to nsaudit'
FROM information_schema.TABLES WHERE table_schema ='public'

2. mt_sys_menu无法创建问题，link属性问题

kingbase.conf中添加

exclude_reserved_words='link'